Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range(Selection...question
This may not actually be a macro question but the solution will affect the work I need to do in a marco. I have a worksheet of addresses where selection keystrokes (Ctrl+Shift+Right Arrow) as well as macro code such as "Range(Selection, Selection.End(xlToRight)).Select" work on the header row but these selection techniques don't work on the actual address rows. The way I use either method is I place the cursor on data in the first row and either use C+S+R or execute a macro using a keyboard shortcut assigned to that marco. Either way, the only data that gets selected is the next row to the right, not the entire row of data. Both methods work fine in the header row only. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=397279 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range(Selection...question
that action selects to but not including the next empty cell if the first
cell to the right and the active cell are not empty. range(cells(1,Activecell.Column),cells(1,ActiveCel l.column).End(xltoRight)). Offset(ActiveCell.row-1,0).Select might do what you want. -- Regards, Tom Ogilvy "JimDandy" wrote in message ... This may not actually be a macro question but the solution will affect the work I need to do in a marco. I have a worksheet of addresses where selection keystrokes (Ctrl+Shift+Right Arrow) as well as macro code such as "Range(Selection, Selection.End(xlToRight)).Select" work on the header row but these selection techniques don't work on the actual address rows. The way I use either method is I place the cursor on data in the first row and either use C+S+R or execute a macro using a keyboard shortcut assigned to that marco. Either way, the only data that gets selected is the next row to the right, not the entire row of data. Both methods work fine in the header row only. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=397279 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range(Selection...question
Thanks! That was it, I really appreciate your help. -- JimDandy ------------------------------------------------------------------------ JimDandy's Profile: http://www.excelforum.com/member.php...o&userid=16578 View this thread: http://www.excelforum.com/showthread...hreadid=397279 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA range selection question | Excel Worksheet Functions | |||
Narrow Range based on Selection in Another Range | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
Creating range name for a range selection | Excel Programming |