Does anyone see why this Macro doesnt work?
I have two Macros. One created Through the Recorder, the other Taken from the net and tweaked a bit.
I am trying to get the to sort the worksheet by color.
Macro 1: This one works fine. (Generated from the recorder)
This One as taken from the net and Worked Awsome for Selecting the cells I wanted, but doesnt make it to the sorting, it errors out with:Please Login or Register to view this content.
This happens as soon as I run the .Apply line:Run Time error '1004'
The Sort reference is not valid. Make sure that its within the data you want to sort, and the first Sort By box isnt the same or blank
Here is the code:
Any Ideas? I even tried pasting the exact code from the Recorded Macro right after "myUsedRange.Select" and got the same error.Please Login or Register to view this content.
Bookmarks