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.
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Oaktree

MrExcel MVP
Joined
Jun 20, 2002
Messages
8,053
Office Version
  1. 365
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:
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,853
Messages
5,833,991
Members
430,250
Latest member
Reggie Mcqueen

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