Macro only for Alphabetic Sheets
Solved/Closed
smuneeb
smuneeb
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
smuneeb
- Posts
- 77
- Registration date
- Saturday September 5, 2015
- Status
- Member
- Last seen
- March 8, 2017
Related:
- Macro only for Alphabetic Sheets
- Macro to create new sheet and copy data - Forum - Excel
- Excel macro to create new sheet based on value in cells - Guide
- Macro to Create New Workbook and Copy Data at Each Change of X - Forum - Excel
- Macro to Compare two sheet with both sheets - How-To - Excel
- Macro to unprotect excel sheet - Guide
1 reply
TrowaD
Jun 2, 2016 at 11:33 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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