using for loop for vba

Can you please try this? Idea would be something like this.

Dim FileNo As String

For i = 1 To 35
FileNo = "File" & i
Windows(FileNo).Activate

'Rest of the code
Next

Browse More Popular Posts

Leave a Comment