Quick question about "Empty"

[oric]

Hi all,

So I ran across an issue today. I wrote some code that basically goes down each cell in a specific column and does stuff until it reaches the last filled cell (first empty). It looks something like.

Do While ActiveCell.Value <> Empty

stuff....

Activecell.Offset (1,0).Select

Loop

Well I found when there is a value of zero in one of the cells it views this as Empty and my code stops.

Does anyone know of a way I can get around this? Some of my values will be zeroes and there will be more data below this cell which I need access.

thanks in advance.

 

[Hap]

try changing Empty to ""

 

[Oaktree]

Use Range("A65536").end(xlup) to reference the last cell in column A

For example:

For each cell in range ("A2:A"&Range("A65536").end(xlup).row)
'rest of code here
next

 

[oric]

Thanks for the insight.

Changing Empty to "" was quite easy to implement.


worked like a charm.

many thx