Auto-sort but stay with cell just entered.

[Hest20]

Hi,

I have worked out how to sort by date every time a new value is entered in column B:

Please Login or Register  to view this content.

However, after entering the date, I need to enter more info into the same row and I can no longer find the row I need as it has been sorted somewhere into the list.

Is there any way I can auto sort but get Excel to remember which cell I have just edited and take me to it??

Administrative Note:

• Please see Forum Rule #3 about code tags...
• Added for you this time, but please use them in the future…Thanks.

[xladept]

Have you tried something like:

Please Login or Register  to view this content.

[Hest20]

Hi,

Thanks a lot for your reply. I have tried the code and it come up with error "Object variable With block variable not set"

Any ideas?

[xladept]

Sorry - I forgot to Set the object but I also forgot to activate the finder - try this:

Please Login or Register  to view this content.