Hi All,
I need to loop through a series of worksheets and I have the worksheets DIMed As String so I can reference them.
I can't get the loop to recognise the number of the assigned Worksheet.
How do I get ws to equal the i?![]()
Sub LoopDIM() Dim ws1 As String Dim ws2 As String Dim ws3 As String Dim ws4 As String WS1 = "Tab1" WS2 = "Tab2" WS3 = "Tab3" WS4 = "Tab4" For i = 1 to 10 Sheets(ws, i).Select Range("A1").select Next End Sub
Any help appreciated
Cheers
Dean
Bookmarks