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?

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?

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?