Testing a cell for value

[goofy78270]

I am using the following in the beginning of a macro but it never passes due to the last line.

Please Login or Register  to view this content.

A2 = 1 - in the Empower Import sheet

Should I be doing this evaluation another way?

[rylo]

Hi

What are you doing in the while loop? Incrementing RowCount?


rylo

[goofy78270]

Yes, Iam am incrementing RowCount within the loop but the problem is that it never gets into the loop. The Do While never evaluates. During debug, I can see that RowCount is at 2 but the Cells(RowCount, 1) never evaluates.

[rylo]

Hi

So presumably there is nothing in A2???


rylo

[goofy78270]

Silly me, I was trying to do this within a sheet and not a module. I have since moved this to a module and all is great.

Sorry for being silly