VBA version of ISBLANK()

[Nicholas B]

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

[Nicholas B]

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
>

[Jim Cone]

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



"Nicholas B" <NicholasB@discussions.microsoft.com>
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

"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
>