Issue using iRow

**faoltaem** · 11-14-2012, 09:32 PM

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** · 11-14-2012, 09:39 PM

You have a space before one of the Ws here.

Formula:

Please Login or Register  to view this content.

**protonLeah** · 11-14-2012, 09:49 PM

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

**faoltaem** · 11-14-2012, 10:27 PM

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** · 11-14-2012, 10:30 PM

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

Please Login or Register  to view this content.

**faoltaem** · 11-15-2012, 03:00 AM

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

Issue using iRow

LinkBack

Thread Tools

Rate This Thread

Display

Issue using iRow

Re: Issue using iRow

Re: Issue using iRow

Re: Issue using iRow

Re: Issue using iRow

Re: Issue using iRow

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions