View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronnie Ronnie is offline
external usenet poster
 
Posts: 53
Default For Loops and Named ranges

I have ranges named in my worksheet (ques1, ques2, etc) and I would like to
use a loop to clear the contents of these ranges.

Something like:
For i = 1 To 60
Range("ques i ").Select
Selection.ClearContents
Next i
End Sub

Any suggestions on how to make this work?