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

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

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