If you want the cell above the activecell:
if activecell.offset(-1,0).value = "" then

if you want one column to the left:
if activecell.offset(0,-1).value = "" then

If you want on column to the left and one row up:
if activecell.offset(-1,-1).value = "" then



aca wrote:

In a macro,
What is the syntax for a conditional line,
the condition being the contents of a cell referred to with the style
RC[-1 ] (same Row as the current cell, but Column one above)?

Something like
------------------------------------------------
If ??????? RC[-1 ] ??? = ""Then
ActiveCell = "The cell above-left is empty"
End If
------------------------------------------------
What should the first half of my 1st line be?

I'll feel very grateful to anyone who can help.
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