Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulation of Selection.Address
Is there a variable type that i can save Selection.Address into that i can manipulate??? Basically i'm finding the first empty cell of on a column of the sheet by: Dim LastRow As Range Set LastRow = Cells(Rows.count, "C").End(xlUp) LastRow.Offset(1).Select (thanks Don G) After that i'd like to be able to select another column, but the same row that LastRow.Offset(1).Select Selected. Thanks for any help you may be able to offer, Chris -- cbh35711 ------------------------------------------------------------------------ cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276 View this thread: http://www.excelforum.com/showthread...hreadid=527784 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulation of Selection.Address
To select the cellin column F
LastRow.Offset(1, 3).Select -- Regards Ron de Bruin http://www.rondebruin.nl "cbh35711" wrote in message ... Is there a variable type that i can save Selection.Address into that i can manipulate??? Basically i'm finding the first empty cell of on a column of the sheet by: Dim LastRow As Range Set LastRow = Cells(Rows.count, "C").End(xlUp) LastRow.Offset(1).Select (thanks Don G) After that i'd like to be able to select another column, but the same row that LastRow.Offset(1).Select Selected. Thanks for any help you may be able to offer, Chris -- cbh35711 ------------------------------------------------------------------------ cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276 View this thread: http://www.excelforum.com/showthread...hreadid=527784 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulation of Selection.Address
Well yeah...that was the next logical step... :) You rock Thanks, Chris -- cbh35711 ------------------------------------------------------------------------ cbh35711's Profile: http://www.excelforum.com/member.php...o&userid=30276 View this thread: http://www.excelforum.com/showthread...hreadid=527784 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning a cell address in a msgbox, by selection via inputbox Ty | Excel Discussion (Misc queries) | |||
Selection Address | Excel Discussion (Misc queries) | |||
Code to send email to address within selection in Excel workbook | Excel Discussion (Misc queries) | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
For better Performance in VBA for Excel - Strings manipulation OR Objects manipulation | Excel Programming |