Macro only for Alphabetic Sheets [Solved/Closed]

Question

Previous Topic Next Topic

Macro only for Alphabetic Sheets [Solved/Closed]

Report

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 - Run a macro when opening a sheet - How-To - Excel
Macro to Compare two sheet with both sheets - How-To - Excel
Excel macro to create new sheet based on value in cells - How-To - Excel
How to specify macro for current active sheet ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-06-02T11:33:33-0400

Answer 1 / 1

TrowaD

Posts: 2757
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: June 8, 2021

462
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

Report

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

Macro only for Alphabetic Sheets [Solved/Closed]

1 reply

Your reply

Subscribe To Our Newsletter!