Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Confused with variable
Greetings,
I have a named range called WorksheetNames. I want to cycle through them and do a set of operations. I wrote the following simplified code, however, I can't seem to get the Name to work in the Worksheets() convention. Dim Name As Range For Each Name in Range("WorsheetNames") Worksheet(Name).Cells(1,1).Value = "No Flag Set" Other code Next Name Would someone explain what I am missing? Thanks, Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Now I'm Really Confused | New Users to Excel | |||
confused. Please help. | Excel Discussion (Misc queries) | |||
Very confused.... | Excel Discussion (Misc queries) | |||
confused,please help | Excel Discussion (Misc queries) | |||
confused... | Excel Programming |