VBA to sort columns left to right - oldest to newest

Hi,

I'm trying to sort some data i have loaded into my templates, following my copy paste code i would like to add some more code to sort the data left to right and oldest to newest.

Any ideas on how to do this;

The sheet name is IPD and the range i want to sort is D:AA

You can use excels built in sort for this...
using the macro recorder gives something like:

Please Login or Register  to view this content.

so you probably need something like:

Please Login or Register  to view this content.

assuming row 1 contains your dates you want to sort by or something like that.

Thanks i've added this to my code as follows;

Please Login or Register  to view this content.

small comment, the with loop doesn't do anything, you need:

Please Login or Register  to view this content.

for the with sheets("IDP") to apply to the range.

Thanks, i've changed that and it brings an error;

'Sort method of range class failed'

Can you upload an example workbook please?

Here's a sample, workbbok is a lot bigger but trimmed down to fit upload limit.

The sheet in your workbook is "IPD" but the sheetnamen in your code is "IDP"...

If I change it to:

Please Login or Register  to view this content.

It works for me

Many thanks