Quick question about "Empty"

oric

New Member
Joined
Jul 19, 2005
Messages
36
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.

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.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,988
Use Range("A65536").end(xlup) to reference the last cell in column A

For example:

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

oric

New Member
Joined
Jul 19, 2005
Messages
36
Thanks for the insight.

Changing Empty to "" was quite easy to implement.


worked like a charm.

many thx :biggrin:
 

Watch MrExcel Video

Forum statistics

Threads
1,118,812
Messages
5,574,455
Members
412,595
Latest member
slim313
Top