Report

Macro only for Alphabetic Sheets [Solved]

Ask a question smuneeb 74Posts Saturday September 5, 2015Registration date June 3, 2016 Last seen - Latest answer on Jun 3, 2016 09:10AM
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
See more 
Helpful
+0
moins plus
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
smuneeb 74Posts Saturday September 5, 2015Registration date June 3, 2016 Last seen - Jun 3, 2016 09:10AM
Hi
TrowaD
Highly appreciable for your work

Thanks & Regards
Reply
Add comment

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.

Not a member yet?

sign-up, it takes less than a minute and it's free!