named ranges in a For Loop
i think jim gave you a suggestion in your original post 2 days ago. did you
try it?
--
Gary
wrote in message
oups.com...
I have named ranges in a worksheet (ques1, ques2,etc.). I need a loop
to clear the contents of these ranges, something like:
For i = 1 To 60
Range("ques & i").Select
Selection.ClearContents
Next i
Any suggestions on how to make this work?
|