Establish if Offset RANGE contains text
I wish to establish if an offset RANGE contains text.
so, activecell and the cell below can be merged, and then populated.
something like....
if Range(ActiveCell.Offset(0, 0), ActiveCell.Offset(1, 0)).value is
nothing then
my macro
else
my macro
end if
Can anybody please help?
|