Greetings,
Did some research I found code to create a autosort macro, which should sort of today's date in cell A1, that way I always have the most recent entries at the top of my sheet. It will work fine for a while then all of a sudden it refuses to move the content of cell A5 (the first in the sort) to it's correctly sorted location.
Please Login or Register to view this content.
Any help would be greatly appreciated
Are you running it manually or connected it with any events?
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I'm running it from a "save" button in a userform. Sorry I should have put that info from the beginning It was originally in the worksheet_ change event
Last edited by ukyank; 09-16-2013 at 05:43 AM.
do you have a header row? if not, use xlNo instead of xlGuess
Josie
if at first you don't succeed try doing it the way your wife told you to
Hi Joseph header row? I use row 1 - 4 for other info but my sort key is in A1. I'll give xlNo a try, cheers for the info
JosephP - cheers WORKS GREAT NOW!!!! I got to look up xlNo to understand my error. Cheers again!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks