Sort a selection by last column - or sort a range from column B onwards to last empty cell

try

Please Login or Register  to view this content.

Also when posting code please use code tags, the # icon in the reply window.

Hi Both, many thanks. I tried both solutions and the second one was shorter code but I think might get stuck because the top row are merged cells (I inherited the spreadsheet) as it gives a merged cell error. I tried Fluff13's solution and am dissecting how it works but it seems to have done the trick.

Wow, you are all amazing, thankyou for the fast replies within almost minutes, after literally hours of trying to get this to work.

All the best,
Paul

Glad we could help & thanks for the feedback

Hi XLADept,
The rows above B8 (B5:b7 are merged vertically) and C5:D5 merged horizontally (The headings and month ones basically).

I am trying to dissect both bits of code to understand and learn from you both

Best Regards,
Paul

Hi xladept,
I tried that one but I get that "Run-time error '1004': To do this, all merged cells need to be the same size."

Best Regards,
Paul

Is this how you wanted?

Please Login or Register  to view this content.

Hi everyone :D I got it working with the first solution but I always like getting things working when they should but hit a snag, so just uploading the sample spreadsheet just in case it helps with a link.

Please Login or Register  to view this content.

Apologies for the garbled code hash link, it would let me post the prefixed version as I haven't posted enough yet.

All the best,
Paul

Originally Posted by jindon

Is this how you wanted?

Please Login or Register  to view this content.

Hi Jindon,
Wow I’ve never even seen the intersect command, going to look it up. I pasted it in and it seemed to sort something but not the last column.

Regards,
Paul

Originally Posted by atombomb99

I pasted it in and it seemed to sort something but not the last column.

It is working here, sort by the last column.
I need to see your workbook, if it is not working at your end.



Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.