Test for a Blank Cell Below Active Cell

[Vamphyri]

I have been searching for this one quite a bit, but cannot find exactly what I'm looking for.

I need to figure out how to test for a blank cell, using OFFSET, 1 row below th eactive cell.

Here's what I came up with:

If Offset(0, 1) = "" Then
            Exit Sub
        Else

Unfortunately, the code errors out on the first line with "Sub or Function Not Defined".

Any ideas on how to do this one?

Thanks


In the immortal words of Socrates, who said:
"I drank what?

 

[PHV]

If ActiveCell.Offset(0, 1) = "" Then

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[mscallisto]

how to test for a blank cell

Cells with blank (aka space) differ from empty cells.


are you looking for a cell with a blank (like if you hit the space bar while in the cell, or you deleted the contents of a cell)

OR one with a null value (has never been populated or has been set to null)

 

[SkipVought]

If you are looking for an empty cell below the activecell...

if activecell.offset(1) = "" then

If you are looking for an empty cell to the right of the activecell...

if activecell.offset(0,1) = "" then

Skip,

_{Have you heard that the roundest knight at King Arthur's round table was...
Sir Cumference!}

 

[AnotherHiggins]

mscallisto,
In Excel, =IsBlank(CellRef) returns TRUE if the cell is empty, whether it has always been null or the contents have been deleted. So a cell containing one "space" character (ie chr(32) or " ") is not considered a Blank cell.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Vamphyri]

PHV,

Excellent!

Thanks


In the immortal words of Socrates, who said:
"I drank what?