Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
slightly confused - object reference
i have code looking a little like this:
sub test() dim sht as worksheet dim cll as range for each sht in thisworkbook.worksheets <more code here for each cll in sht.usedrange.columns(2).cells sht.range(cll).select* <code to do soething with selection next cll next sht the problem is that the starred line is wrong, but i have tried everything from sht.cll.select to sht.range("cll").select nothing works. I Just want to select the cell so i can insert a row above it. Any help appreciated. end sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a string to set an object reference? | Excel Programming | |||
Confused about referencing multiple object code rows in other worksheets? | Excel Programming | |||
Confused, again! Object variable not set? | Excel Programming | |||
Get a reference to the last object pasted | Excel Programming | |||
How do I add a reference to an object library using VBA? | Excel Programming |