We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Macro Help in Excel
Comments
-
Hi Richard,
Yeah sort of. All the results from each sheet are totalled up and get added to the end sheet. When that happens I want it to get sorted. I looked at what you suggested but couldn't quite work out how to call the sort macro
Nigel0 -
That's the easy bit :eek:
When the worksheet changes, as part of that macro, just add the line:-
Call Sort
or
Call Module1.Sort (if there is more than one sort macro).
You may need to change sheets for the sort macro tow correctly but it should be easy enough to do.:wall: Flagellation, necrophilia and bestiality - Am I flogging a dead horse? :wall:
Any posts are my opinion and only that. Please read at your own risk.0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.8K Banking & Borrowing
- 254.3K Reduce Debt & Boost Income
- 455.2K Spending & Discounts
- 246.9K Work, Benefits & Business
- 603.4K Mortgages, Homes & Bills
- 178.2K Life & Family
- 261K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards