Report

Macro only for Alphabetic Sheets [Solved]

Ask a question smuneeb 76Posts Saturday September 5, 2015Registration date October 12, 2016 Last seen - Last answered 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 76Posts Saturday September 5, 2015Registration date October 12, 2016 Last seen - Jun 3, 2016 09:10AM
Hi
TrowaD
Highly appreciable for your work

Thanks & Regards
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!