just a smidgeon of correction to VBA sort list code please

[yogup]

Hi

I have this code (below) which copies data from ws "safeguard" ws "log" using an autofilter for today's date. I then want the data in ws "log" to be sorted in descending date order. it does not seem to incorporate the newly added data to the sort though. Any ideas where i am going wrong?

thanks

Please Login or Register  to view this content.

[shg]

Please take a few minutes to re-read the forum rules, and then edit your post to amend the thread title accordingly and add CODE tags.

Thanks.

[yogup]

amendments now made, apologies

[shg]

I can't tell what you're trying to do. Maybe this:

Please Login or Register  to view this content.

[yogup]

thanks that works well apart from it copies the header row too unfortunately

[shg]

Please Login or Register  to view this content.

[yogup]

That's magic thanks. just getting my head around it all again and everyone has slightly different ways of coding

[shg]

You're welcome.