Hello, I am very new to Excel and trying to learn how to shorten a marco that is recorded. Looking at the VBA code below, can you please offer any tips or advice to shorten the code. I am looking more for an explination of some things as opposed to someone solving shortening the code so I can learn. Thank you!
Please Login or Register to view this content.
Last edited by swhite7; 07-02-2013 at 06:50 PM. Reason: Update Tags
could you
(a) put code tags so code is easier to read?
(b) explain what it's supposed to achieve?
swhite7,
Welcome to the forum! In the future, please wrap your code in code tags (link in my sig for how).
As for your question, here is a re-written version of your code. I have included comments to help you understand.
You may want to look up the Range.Sort method in order to really learn what the code is doing.
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks