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

"Nicholas B" wrote:

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