Need Macro to run no matter what a worksheet is name

[roxie]

Hello,

Have several users running this report. Depending on the user the first worksheet may have a different name - ex. FGlistmonthly or Design_Responsibility_name, etc. Second Worksheet may be Sheet1 or Sheet5, etc. Need Macro to run no matter what the Worksheets are name without having to change Macro if possible. Usually is what I do to match the Worksheet name. Thanks for any help.

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
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 at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

[jolivanes]

The answer is in your code.
Use the With and End With statement

Please Login or Register  to view this content.

Make sure to use the . (period) as required.

BTW, read up on selecting. In your code it is not needed at all. It slows down the code.

Oh, instead of all the changing of the column widths, would this not work at the end?

Please Login or Register  to view this content.

Is there a good reason why some columns are deleted and shifted right, others left and other cut?
The deleting and inserting columns is a mixed bag also. Not a good way of doing it. I realize it was a recorded macro but you should clean it up.
Maybe if you explain what you want done, someone will come up with a neater and certainly faster and better piece of code.

[roxie]

Sorry about not posting code between

Please Login or Register  to view this content.

tags. Thanks for your help!

[roxie]

Hi Jolivanes,

Trying to do this on my own but unfortunately I don't have much time and the end of the month is coming fast.
Thanks for all your help!
In my brief tutorial studies I had not come across the Autofit line. Mostly been creating programs that say "Hello". But that line worked!
I will definitely read up on selecting and see how much more I can clean this up.

Thanks again!
roxie

[JOHN H. DAVIS]

You can also place this at the beginning of your code

Please Login or Register  to view this content.

[roxie]

Hi John,

I'll try this also.

Thanks for your help!