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
smuneeb Posts 67 Registration date Saturday September 5, 2015 Status Member Last seen March 8, 2017 - Jun 3, 2016 at 09:10 AM
Related:
- Macro only for Alphabetic Sheets
- Sheets right to left - Guide
- Spell number in excel without macro - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Macro excel download - Download - Spreadsheets
- How to move between sheets in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 2, 2016 at 11:33 AM
Jun 2, 2016 at 11:33 AM
Hi Smuneeb,
Try the following code, where you enter your code where the green text is:
Best regards,
Trowa
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
Jun 3, 2016 at 09:10 AM
TrowaD
Highly appreciable for your work
Thanks & Regards