Creating a VBA script to sort a selected group via custom sort.

[jpt145]

Hello i am new to the forum world so please bare with me.

I have been creating Macro's to simplify tasks, my main source of creation has been by recording Macros which has done its far share of help. But I finally have hit a bit of a road block here when trying to record a macro selecting a certain area and then sorting it via the custom sort option under "sort & Filter"... I am sorting with three levels selected.. and am trying to have the Macro create these new levels and run on any new workbook not just a specified work book name which is were my issue comes in, every time I record I get it stated to work with "ActiveWorkbook.Worksheets("sheet1")" which provides an issue as you can imagine because the other work books names are not the same.
here is the Code i want to run on any workbook i open and run it on. is there an alternative to "Activeworkbook.worksheets("")?

Please Login or Register  to view this content.

Thank you !

[TMS]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however you need to include code tags around your code.

Please take a moment to add the tags. Posting code between tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Rule #2 about code tags and adjust accordingly. Click on Edit to open your post, then 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

(Note: this change is not optional.)




Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[jpt145]

Thank you for the Welcome TMS!
Sorry about not noting the Code i have edited it please if you get the chance double check.

[TMS]

Thanks

Try this:

Please Login or Register  to view this content.

[maniacb]

Or you cn try replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.