I have a named ranges on a sheet....team_1, team_2 , team_3... etc
How can I refer to them in code using a variable?
something like his
dim x as integer
dim myrange as range
For x = 1 To 30
Set myrange = range(team_x)
'do something to myrange
Next x
Bookmarks