Issue using iRow

[faoltaem]

Hi,

Having an issue with a VBA formula. The formula will work while I have a specific cell identified (eg. J2), but when I elect for the row number to be ‘iRow’ it mysteriously won’t work. Just to clarify I have the parameters for ‘iRow’ set up, and they do work with other formulas I have running just not this one.

The broken code:

Please Login or Register  to view this content.

Other codes that do work:
(basically the same thing, just 2 instead of iRow)

Please Login or Register  to view this content.

&
(test that iRow is working)

Please Login or Register  to view this content.

Any ideas?

[Norie]

You have a space before one of the Ws here.

Please Login or Register  to view this content.

[protonLeah]

You have some characters: ” & “ in your code that are not quotation marks (")

[faoltaem]

Thanks, still not working for me, fixed the spaces:

Please Login or Register  to view this content.

The " & iRow & " is still there because that's how iRow works. And I've had to break it over two lines since it doesn't fit on one.

The error I get says:
Compile error:
Expected: end of statement

[Norie]

To continue a string on a new line you need to concatenate.

Please Login or Register  to view this content.

[faoltaem]

Oh, thank you so much. That has been driving me crazy. I thought { _} was the correct way to concatenate, turns out it's {" & _"}.