Dave Peterson, Tim Williams, Tom Ogilvy....
Tank you so much to all of you.
I see my message has triggered a crossfire of friendly exchanges due to
a mistake I must have made in my previous reply, thanking the wrong
person. Well thankfulness is never wrong, for you all have helped me
greatly.
If you are curious to know, the solution (coming from one of you)
that exactly suits my problem is this:
---------------------------------------------------
If ActiveSheet.Cells(ActiveCell.Row - 1, "B").Value = "" Then
ActiveCell = "The cell, in column B and Row above this one, is empty"
End If
-------------------------------------------------
Again, my threefold thank you
ACA
--
aca
------------------------------------------------------------------------
aca's Profile:
http://www.excelforum.com/member.php...o&userid=25933
View this thread:
http://www.excelforum.com/showthread...hreadid=539539