| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
for each question
say i have set rng1 to A1:A10, rng2 to B1:b10, rng3 to C1:c10
when i do a for each loop, would ii be possible to use a variable to add the number onto the rng? -- Gary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for each question
No. you can't do anything like
for i = 1 to 3 msgbox (rng & i).Address Next What are you really trying to do? -- Regards, Tom Ogilvy "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... say i have set rng1 to A1:A10, rng2 to B1:b10, rng3 to C1:c10 when i do a for each loop, would ii be possible to use a variable to add the number onto the rng? -- Gary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for each question
decided not to go this route, sorry.
-- Gary "Gary Keramidas" <GKeramidasATmsn.com wrote in message ... say i have set rng1 to A1:A10, rng2 to B1:b10, rng3 to C1:c10 when i do a for each loop, would ii be possible to use a variable to add the number onto the rng? -- Gary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
