View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] ronnie_knight@msn.com is offline
external usenet poster
 
Posts: 2
Default named ranges in a For Loop

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?