VBA version of ISBLANK()

[Guest]

Anyone know how to get VBA to check if a cell is blank before reading its
formula ?

If it was just a single cell I can point to it using a formula [ Eg
=ISBLANK(D12) ] and use VBA to read the value of that Cell (the one with the
ISBLANK() Formula).

But I've many cells I want to test, cannot find a VBA equivalent to
ISBLANK() and if I use the following line

FormulaB4Change = CStr(ActiveCell.Formula)

The code crashes on empty cells

Nick

 

[Guest]

OK Ignore this. I'm wrong. Doesn't crash on ALL empty cells just one
particular cell
Have tried IsEmpty() but that still crashes

Thanks

 

[Jim Cone]

Nick,
You could also use Len(a cell reference)
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware



"Nicholas B" <[email protected]>
wrote in message...
OK Ignore this. I'm wrong. Doesn't crash on ALL empty cells just one
particular cell
Have tried IsEmpty() but that still crashes

Thanks