Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Robert Richardson   on Jan 12 In MS Office Category.

  
Question Answered By: Virgil Foster   on Jan 12

Try:
Sub pnahra()
For x = 1 To 200 Step 10
Range(Cells(x, 1), Cells(x + 9, 1)).Select
'do something here
Next x
End Sub

or:

Sub pnahra()
For x = 1 To 200 Step 10
Range("A" & x & ":A" & x + 9).Select
'do something here
Next x
End Sub

Share: 

 
 
Didn't find what you were looking for? Find more on How to declare a range using a variable Or get search suggestion and latest updates.


Tagged: