| 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
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 |
|
#6
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 |
|
#7
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 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
Dave Peterson, Tim Williams, Tom Ogilvy.... Tank you so much to all of you. I see my message has triggered a crossfire of friendly exchanges due to a mistake I must have made in my previous reply, thanking the wrong person. Well thankfulness is never wrong, for you all have helped me greatly. If you are curious to know, the solution (coming from one of you) that exactly suits my problem is this: --------------------------------------------------- If ActiveSheet.Cells(ActiveCell.Row - 1, "B").Value = "" Then ActiveCell = "The cell, in column B and Row above this one, is empty" End If ------------------------------------------------- Again, my threefold thank you ACA -- aca ------------------------------------------------------------------------ aca's Profile: http://www.excelforum.com/member.php...o&userid=25933 View this thread: http://www.excelforum.com/showthread...hreadid=539539 |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
R1C1 style reference as Condition
I'm sure I join the others in saying that we're glad you got your problem
resolved. aca wrote: Dave Peterson, Tim Williams, Tom Ogilvy.... Tank you so much to all of you. I see my message has triggered a crossfire of friendly exchanges due to a mistake I must have made in my previous reply, thanking the wrong person. Well thankfulness is never wrong, for you all have helped me greatly. If you are curious to know, the solution (coming from one of you) that exactly suits my problem is this: --------------------------------------------------- If ActiveSheet.Cells(ActiveCell.Row - 1, "B").Value = "" Then ActiveCell = "The cell, in column B and Row above this one, is empty" End If ------------------------------------------------- Again, my threefold thank you 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 |
| 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)
Linear Mode
