VBA Data Sort

[hobbiton73]

Hi, I wonder whether someone may be able to help me please.

I'm using the snippet of code below to perform a series of actions on a given array.

Please Login or Register  to view this content.

I'm now trying to sort, in the case of the above, columns B:F ascending via column B.

I've done quite a bit of searching and in all honesty the examples on line have made me more confused than when I started.

I just wondered whether someone may be able to look at this please and offers some guidance on how I can add the 'Data Sort' function.

Many thanks and kind regards

[stnkynts]

Don't forget that there is the "Record Macro" feature which could have fairly easily given you the answer. That is what I did to show you what it looks like:

Please Login or Register  to view this content.

[hobbiton73]

Hi @stnkynts, thank you very much for taking the time to reply to my post and for the solution and advice.

Initially, I couldn't get your code to work, simply down to changes I had to make to cater for the header row. So I tried your suggestion and recorded the macro and it now works perfectly, thank you!

My main area of confusion was how to incorporate the 'LastRow' range with the data sort, but as I said your solution works great.

Many thanks and kind regards