I have a spreadsheet (A250:T250). I'd like for the rows to resort based on the content in column A when any changes are made in column A. Right now it will automatically sort, but it sorts any time a change is made to any cell in the A250:T250 range and then the cursor automatically moves back to A1 each time. I'd like for the resort to occur only if changes are made in column A.
What is the current sort code that you have?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Please Login or Register to view this content.
Last edited by hinesgg; 04-04-2012 at 10:45 AM.
Hello hinsegg,
Welcome to the Forum!
Here is your macro with the required changes.
Please Login or Register to view this content.
Last edited by Leith Ross; 04-05-2012 at 07:05 PM. Reason: Corrected Spelling of Intersect (bold text)
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks, but I get a VB error message. Compile error: Sub or Function not defined and it stops on the word Intersect.
If you cut and paste the code from this forum then it's cos he misspelt the word Intersect.
@swoop99,
Thanks for spotting the error. I have corrected the spelling.
Working like a charm. Thanks all.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks