Sort using VBA giving error.....please help

[welchs101]

I am doing this sort in VBA and i keep getting this error

"The sort reference is not valid. Make sure that its within the data you want to sort and the first sory by box isnt the same or blank.

Please Login or Register  to view this content.

i am at a loss. My data table is A1:U1145.

sort_col1 = 1
sort_col2=20
sort_col3=21

please help!

[TMS]

Can we see the workbook with this code in it? With some sample data?

I'd want to step through and see what was in the variables.

Regards

[welchs101]

i wish i could post the data.........but i cant right now

I did do a macro record and then put this into the code and it worked.......take a look . any ideas on why this worked please please please please let me know!!!!!!!!!!!!!! I just cant figure it out.

Please Login or Register  to view this content.

[welchs101]

here is the same code but with a few variable names

Please Login or Register  to view this content.

[romperstomper]

Original code should have been:

Please Login or Register  to view this content.

so that all Range calls are qualified with the worksheet.

[snb]

Please Login or Register  to view this content.

PS. Please do not use 'Help'or 'Please' in the threadtitle. The readability of your post won't be improved by using an abundance of exclamationsigns either.

[welchs101]

Romperstomper,

YOU ARE THE MAN!!!!!!!!!!

Thanks to all who tried to help much appreicated!!!!!!!!!!!!

It worked......i added the with and end-with (ie...i added the code you suggested) and it worked!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!



THANKS!

[welchs101]

snb,

sorry i wont use such language again.......i was just really frustrated........but again sorry!


Also the code from snb works great as well!

THANKS GUYS!

[romperstomper]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save