if cell is empty in excel 1

[Daya100]

I'm trying to identify when a cell has not had information entered so that I can give an error. I have tried using IsEmpty and IsNull but nothing seems to work. How do I do this?
Thanks!
Daya

 

[SkipVought]

Hi,
Try this (in this case it's looking at A1)...

    Select Case Cells(1, 1).Value
        Case Null, Empty, ""
            MsgBox "Enter Data"
    End Select

Hope this helps Skip,
metzgsk@voughtaircraft.com