Incrementing vba code variables

[zakynthos]

I have 100 log sheets Logr1 to Logr100 and want to use the code below to navigate between sheets

What would be the code to increase 'Logr1' in one hundred copies of this code in increments of 1?

Sheets("Logr1").Select
Range("v1:ap20").Select
Selection.ClearContents

So that it runs from the above to

Sheets("Logr100").Select
Range("v1:ap20").Select
Selection.ClearContents

This would be particularly useful as I could then adapt it for other changes I wish to make to a large program.

Many thanks

 

[RoryA]

Dim n as long
for n = 1 to 100
   Sheets("Logr" & n).Range("v1:ap20").ClearContents
Next n

for example.

 

[zakynthos]

Thanks for your quick (and very helpful) answer.