Code To Sort Specific Range

[timbo1957]

I need to sort from the bottom row of the spreadhseet up to and including row 5 by the values in column X Ascending order could someone give me a piece of code that would do this please?

[Kyle123]

Morning,

Can't you just click on the column and sort Z>A?

[timbo1957]

No that will include the header rows, I need something will only sort from row 5 down on a spreadhseet that is constantly changing length, hence from the bottom up to row 5.

[Kyle123]

How may columns do you have?

[timbo1957]

125 columns in total, rows currently 309 (that includes the first 4 rows I don't want sorted)

[Kyle123]

Try something like this:

Please Login or Register  to view this content.

[timbo1957]

Hi Kyle123

That doesn't work, I have changed the ranges to suit as follows -

Please Login or Register  to view this content.

[watersev]

hi, timbo1957, try this option:

Please Login or Register  to view this content.

amend last row definition to your actual data layout

[timbo1957]

Thanks watersev, worked a treat!