Dealing with 'empty' cells in a formula

[t16turbo]

My spreadsheet has some empty cells in it.

I have tried using the code

If IsNull(ActiveCell.Value) Then
my_variable = 0
Else: my_variable = ActiveCell.Value
End If

but this doesn't work, as it just goes straight into the Else section.
How can I cater for empty cells?

 

[JerryKlmns]

maybe

If ActiveCell.Value & "" = "" Then
my_variable = 0
Else
my_variable = ActiveCell.Value
End If

 

[PHV]

Or perhaps this:
If Trim(ActiveCell.Value & "") = "" Then

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

Hi,

FYI...

EMPTY means the the cell contains neither a VALUE nor a FORMULA. Even if a formula returns "", it is NOT EMPTY.


Skip,

_{[red]Be Advised![/red]
A wee deranged psychic may be runnin' around out there!
SMALL MEDUIM @ LARGE}

 

[vbap]

If the cell contains nothing not even "" ....try

If IsEmpty(ActiveCell)=True then
my_variable=0
Else
my_variable=ActiveCell.Value
End If

Null is not the same as Empty, which indicates that a variable has not yet been initialized. It is also not the same as a zero-length string (""), which is sometimes referred to as a null string.