Thread
:
Dynamically reference worksheet code name
View Single Post
#
1
Posted to microsoft.public.excel.programming
Barb Reinhardt
external usenet poster
Posts: 3,355
Dynamically reference worksheet code name
I'd like to do something like the following
For i = 1 to 10
Set aws = "Test" & i 'Test1-test10 are worksheet code names
'perform actions on aws
next i
How do I do this?
Thanks,
Barb Reinhardt
Reply With Quote
Barb Reinhardt
View Public Profile
Find all posts by Barb Reinhardt