Wildcard for Different Sheet names

[eagle670]

I have a macro that I have to run on 6 different worksheets. Each sheet has a different name. Rather than having to edit the macro to coorespond with the specific sheet that I am running, is there a way to use a wildcard for the sheet name that will allow it to run?

Here is the portion of the macro that has to be edited each time to the different file name. ("FW CONVERSION")

Please Login or Register  to view this content.

[millz]

Please use [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags when posting codes. See rule #3 of Forum rules.


If you want people to suggest or give you a solution maybe at least list out the names of your worksheets?

[eagle670]

Sorry about that.

[millz]

No need to be sorry, it's fine, just edit your post and add in the tags.

And as for your request, list out all the worksheet names that you have. No one can provide a "wild card" match just by looking at one worksheet name.

[eagle670]

My different worksheet names are as follows

FW CONVERSION
GC CONVERSION
KC CONVERSION
SP CONVERSION
OK CONVERSION
NV CONVERSION
ME CONVERSION

[millz]

You still haven't edit your first post.


Try this

Please Login or Register  to view this content.

[eagle670]

I am getting a next without For error when using your fix. Here is the entire macro.

Please Login or Register  to view this content.

[Norie]

Is this the code you want to run on all 7 sheets?

[eagle670]

Yes it is. The worksheet name is that only difference between them

[Norie]

What about all the code before the sort code which has no worksheet reference?

[eagle670]

This was the entire macro code. It runs perfectly right now, I only have to change the worksheet name each time before I execute it. Not sure what you are referencing.

[Norie]

All of this code here where no worksheet is referred to.

Please Login or Register  to view this content.

[eagle670]

I apolgize. But I don't know how to answer that. I have copied all of the code that is the macro. I wish I could answer the question because I really need to find a solution for this. Thanks anyway.

[Norie]

Is the code in post #12 to be applied to all 7 sheets?

[eagle670]

Yes it is applied to all 7 sheets.

[eagle670]

Yes it is applied to all 7 sheets.

[millz]

Sorry a small mistake, had 2 "next"'s.

Please Login or Register  to view this content.

[shg]

millz, you need to qualify your range references.

[millz]

millz, you need to qualify your range references.

Right, totally missed the Ranges.

Please Login or Register  to view this content.

[swade730]

Please Login or Register  to view this content.

is this the "wildcard" part of the code? I never seen this before.
what's the protocol for wild card?

[shg]

It's pretty well explained in VBE Help for Like operator

[eagle670]

Thanks for the response, but where in the code does this need to be inserted. Sorry for my ignorance on this, but I guess that's way I am here in the first place.

[eagle670]

Never mind my last post! I figured it out. It works perfectly, thanks so much for all your help, it is appreciated.