Wildcard for Different Sheet names

[eagle670]

I have a macro that I wrote for a specific spreadsheet and I now want to use that macro for other sheets that contain the same data, but have a different worksheet name. I want the macro to ignore the first to characters of the sheet name and I am unsure how to do this.

Here is the specific part of the macro where the sheet name comes into play. I would like the macro to ignore the sheet name all together or just the first 2 characters, because that is the only difference between the speadsheets that I will run it against.

Cells.Select
ActiveWorkbook.Worksheets("FW POG CONVERSION REFRESH FILE").Sort.SortFields. _
Clear
ActiveWorkbook.Worksheets("FW POG CONVERSION REFRESH FILE").Sort.SortFields. _
Add Key:=Range("A2:A34239"), SortOn:=xlSortOnValues, Order:=xlAscending, _
DataOption:=xlSortNormal
ActiveWorkbook.Worksheets("FW POG CONVERSION REFRESH FILE").Sort.SortFields. _
Add Key:=Range("H2:H34239"), SortOn:=xlSortOnValues, Order:=xlAscending, _
DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("FW POG CONVERSION REFRESH FILE").Sort
.SetRange Range("A1:S34239")
.Header = xlYes
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply

[JOHN H. DAVIS]

Please use code tags when posting. Refer too Forum Rule No. 3. Maybe:

Please Login or Register  to view this content.

[Norie]

Change Worksheets("FW POG CONVERSION REFRESH FILE") to ActiveSheet and the code will run on whicheever sheet is currently active.

[alansidman]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[eagle670]

Here is the code

Please Login or Register  to view this content.