I want to sort all worksheets (identical layout); C1:N75 with headers in row 1. Sort by Total (C1) from largest to smallest. Why isn't my code doing anything?
In ThisWorkbookTrying to help someone (here http://www.excelforum.com/excel-gene...5-sorting.html).
Please Login or Register to view this content.
Last edited by ChemistB; 09-30-2010 at 08:30 AM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
It should be:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
The error is that the control variable of the For Each loop is an object (Romper's code), not a string (as used in your code).
Entia non sunt multiplicanda sine necessitate
and the ranges weren't being qualified with the worksheet.
Yeah, that too
Thanks to both of you. Looks like I need to read some VBA books. I would never have known that through trial and error alone. Thanks Again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks