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

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