Pinaceous
Well-known Member
- Joined
- Jun 11, 2014
- Messages
- 1,113
- Office Version
- 365
- Platform
- Windows
Good Evening Everyone,
I'm curious, if in using the "Select Case" function below can be modified to reflect the Worksheet(#) in lieu of the Sheet Name?
Please let me know, if you can come up with anything.
Thank you,
pinaceous
I'm curious, if in using the "Select Case" function below can be modified to reflect the Worksheet(#) in lieu of the Sheet Name?
VBA Code:
Select Case UCase(ws.Name)
Case "Aq277"
With ws
Call Something
End With
Case "Ar277"
With ws
Call Whatever
End With
End Select
Next ws
Please let me know, if you can come up with anything.
Thank you,
pinaceous