ok..
it's very cool
i stupidly made it complicated
thank nic
thanks bob
--
hemu


"Hemant_india" wrote:

hi
i have following code
dim rng as range
dim rng1 as range
set rng=activesheet.usedrange
set rng1=rng.range("E:E")
for each col in rng1
col.text=somethiing
next
the problem is loop go through every cell in the range

help please
--
hemu