| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
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 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
But I will achieve total consciousness on my deathbed.
So I got that going for me. Dave "I'm not Kreskin" Peterson Tom Ogilvy wrote: 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 -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
Thanks A Lot, Tim: You've Been Great 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 |
| Reply |
| 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)
Hybrid Mode
