| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
| can a1 reference style and r1c1 style be used in same formula? | Excel Worksheet Functions | |||
| How to code with the R1C1 Style of Reference? | Excel Programming | |||
| R1C1 Reference Style won't STAY gone? | Excel Discussion (Misc queries) | |||
| R1C1 reference style | Excel Discussion (Misc queries) | |||
![aca[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
