Thank you David, but your solution is limited to the exemple I gave.

Wow Dave. Need to sharpen those mind reading skills! <LOL

--
Regards,
Tom Ogilvy

"Dave Peterson" wrote in message
...
msgbox activesheet.cells(activecell.row-1,"B").value

maybe...

aca wrote:

Thank you David, but your solution is limited to the exemple I gave.
Instead, I am looking for something with general functionnality
like
------------------------------------
If ????? C2R[-1]??? ="" Then
......
------------------------------------
If the cell in the Row above, but always in Column B, no matter which
column the active cell is in.
ACA

--
aca
------------------------------------------------------------------------
aca's Profile:
http://www.excelforum.com/member.php...o&userid=25933
View this thread:
http://www.excelforum.com/showthread...hreadid=539539

--

Dave Peterson