P
PBcorn
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
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