Error message is sort method of range class failed. 1004. Failure is in the red text.
Please Login or Register to view this content.
Error message is sort method of range class failed. 1004. Failure is in the red text.
Please Login or Register to view this content.
Recorded Macros and copy/pasted, still no worky.
Please Login or Register to view this content.
The code seems to be fine, though split oddly. Replace that line and the one above it with this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Thanks JB,
"The sort reference is not valued. Make sure that it's within the data you want to sort, and the first Sort By box isn't the same or blank."
is the error message i recieve with that code.
and iv'e been working on it for an hour with different snippits from all around....
That error seems to indicate blank cells at the top of your data set.
Code replaced with your JB, and resulting workbook at time of error. Thanks in advance for your help.
Jeremy
The code seems to work fine on your sheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks