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.
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.
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.
Code:
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.