Recognising cell values

[mikeymay]

I am using the following the line of code in a macro

Do Until Activecell = ""

I then use the Offset command to move down cells in the
spreadsheet. Some of these cells have data hard coded
into them and others have a link to another worksheet
within the spreadsheet. If the linked cell has no value,
ie completely blank, then the cells I am checking have
a 'blank' value. when the above code gets the the linked
cell it assigns a value of '0' (zero) and doesn't
recognise is as "". I can't use

Do Until Activecell = 0

as some of the hard coded cell have a value of '00000'
which again is recognised as '0' (zero).

I have tried various combinations to try and resolve but
am not having any joy, can anyone help with what should be
a very simple problem.

 

[Bob Umlas, Excel MVP]

Do Until Len(ActiveCell)=0

Bob Umlas
Excel MVP

 

[Jerry W. Lewis]

Look at Help on the VarType function.

Jerry

 

[Guest]

This doesn't work as the linked cells have a value of 0
which has a LEN value of 1

 

[Dave Peterson]

I think I'd go back to my formula in the cell.

Instead of using
=sheet1!a1
I'd use:
=if(sheet1!a1="","",sheet1!a1)

Then I wouldn't be bothered with those 0's that sometimes mean the sending cell
was blank and sometimes it was a 0.