View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
aca[_9_] aca[_9_] is offline
external usenet poster
 
Posts: 1
Default R1C1 style reference as Condition


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