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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
slightly confused - object reference
Try just
cll.Select you have already drilled down to the individual cell, so you don't need the sheet reference. YOu don't need to select you could just referernce cll. -- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "PBcorn" wrote in message ... 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 |
Reply |
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 |