Macro only for Alphabetic Sheets

Solved/Closed

smuneeb

Posts: 77
Registration date: Saturday September 5, 2015
Status: Member
Last seen: March 8, 2017

- May 28, 2016 at 03:13 PM
smuneeb

Posts: 77
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

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

Answer 1 / 1

TrowaD

Posts: 2886
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 27, 2022

512
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

smuneeb

Posts: 77
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

Subscribe To Our Newsletter!