check a cell is empty or not

Hi,

I was wondering if anyone might be able to help me here. I'd like to check if a certain cell is empty or not. I have tried all the following code but seems not to work.

The cell "B3" currently is empty or null.

Here is my code
if worksheets("Data").range("B3").value <> "" then
'do the following

i have also tried: if not isnull(worksheets("Data").range("B3").value) then

None of these two work. I wonder if i could get some help here.

Thank you in advance

Hi,

Give a try to following :

If Not Worksheets("Data").range("B3")="" Then

HTH
Cheers
Carim

Use this:

If IsEmpty(Worksheets("Data").Range("B3").Value) Then
'Do stuff
End If


- Clay
Excel Help