Columns don't sort properly in VBA

[Frankie_The_Flyer]

Hi Everyone!

I'm in trouble again and it's driving me potty!
I have a code driven by a button that copies and pastes data from column B in worksheet "Team List" into column A in worksheet "Trouble Shooter" and then copies data from column B in worksheet "Division Splits" and pastes it in column B in worksheet "Trouble Shooter". The worksheet "Trouble Shooter" then compares the data in the two columns to ensure they match.
While the data in each is the same, the order it's in differs, so I'm attempting to sort each column into alphabetical order after it's pasted into the "Trouble Shooter" worksheet. I only want each column sorted, not the whole worksheet.
However, it doesn't seem to matter what I do, the columns don't sort alphabetically, or sort at all some times. The code doesn't throw up any errors and once it's run I can sort the columns using Data / Sort without a problem. The columns have headers which are static on the main worksheet.
Here's the bit of the code I have that fails.

Please Login or Register  to view this content.

Thanks in advance

Frankie

[TMS]

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.

[Frankie_The_Flyer]

Have to work on that one as this is part of a multi sheet data loaded workbook at the moment.
I'll get back to you

[Frankie_The_Flyer]

Cracked it thanks. Went a different route!