VBA version of ISBLANK()

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Back
Top