Help with Looping I think
thanks
"Jim Thomlinson" wrote:
Give something like this a try...
Dim rng as range
for each rng in Range("MyRange")
msgbox rng.value
next rng
--
HTH...
Jim Thomlinson
"Mike" wrote:
I have a range of cells A1:A10. I have named the range "Data". How can I
specify to run a procedure for every cell within that range without
specifying cell references? In case a cell is added or deleted to the range
name, I still only want the procedure to dun for the cells within that range
name. Make sense?
|