Macro only for Alphabetic Sheets

Solved/Closed
smuneeb
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
- May 28, 2016 at 03:13 PM
smuneeb
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
- Jun 3, 2016 at 09:10 AM
Hello,

I would like to request for a Macro which will run only for those sheets where Names started with Alphabets from A to Z

Thanks & Regards

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
512
Jun 2, 2016 at 11:33 AM
Hi Smuneeb,

Try the following code, where you enter your code where the green text is:
Sub RunMe()
Dim ws As Worksheet
Dim CheckNum As Double

For Each ws In Worksheets
    ws.Select
    On Error GoTo MyCode
    CheckNum = Left(ws.Name, 1)
Next ws

Exit Sub
MyCode:
'Your code here
Resume Next

End Sub


Best regards,
Trowa
0
smuneeb
Posts
77
Registration date
Saturday September 5, 2015
Status
Member
Last seen
March 8, 2017
1
Jun 3, 2016 at 09:10 AM
Hi
TrowaD
Highly appreciable for your work

Thanks & Regards
0