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

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
7,994
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,123,265
Messages
5,600,603
Members
414,393
Latest member
Vignesh Mechz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top