String Comparison with Array Item and String with VBA in Excel

Question

This is probably a simple one, but I can't seem to find out what's wrong:

if temp_array(1) = temp_string2 & temp_array(2) = "w" then
....
end if

the values are:

temp_array(1) = "test1"

temp_string2 = "test2"

temp_array(2) = "w"

I get a type mismatch error highlighting the conditional comparisons...

GSerg · Accepted Answer · 2012-08-17 18:14:44Z

3

& is string concatenation, not logical and.

if temp_array(1) = temp_string2 And temp_array(2) = "w" then

answered Aug 17, 2012 at 18:14

GSerg

78.8k18 gold badges173 silver badges377 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1