Wheelie686
New Member
- Joined
- Oct 27, 2012
- Messages
- 11
I am trying to loop through the first 4 sheets of a workbook and for some odd reason, it only seems to be doing it on Sheet 1.
Ideally I'd like it to look by the sheet index but I also tried an array with the names... neither one works.
Maybe a typo I just haven't picked up on?
I modified the code to simply select the range just to keep it simple for now.
Ideally I'd like it to look by the sheet index but I also tried an array with the names... neither one works.
Maybe a typo I just haven't picked up on?
VBA Code:
Sub Test()
Dim Sh As Worksheet
For Each Sh In Sheets(Array("Consumer", "Business", "Commercial", "Escalations"))
Range("A2:C182").Select
Next
End Sub
I modified the code to simply select the range just to keep it simple for now.