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 fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

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,416
Messages
5,601,543
Members
414,457
Latest member
Benjamin Musyoki

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