Previous Topic Next Topic

Macro only for Alphabetic Sheets

Solved/Closed
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - May 28, 2016 at 03:13 PM
smuneeb Posts 67 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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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 67 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

Similar discussions

Code for macro that conditionally inserts rows
bfleming -
bfleming -

4 responses
Execute Macro On Calculated Cell change
Notar -
rizvisa1 -

5 responses
Automatically Run Macro from a calculated cell value change
smiller -
TrowaD -

1 response