Excel Sort Macro is just giving me a "400" messagebox!

Please Login or Register  to view this content.

When I run this, it does nothing to the order of the form, and instead pops up a message box saying "400".

Help ?

Gausie

Gausie

I built a small test file with data in b6 to h10 and a value in b23.

Your code worked ok for me and sorted as expected.

I modified your macro to remove alll the if statements whilst still giving you the flexabilty of entering a value in b23 to determine the sort by value

Please Login or Register  to view this content.

If you are still having problems can you reply and attach a copy of your workbook

Sorry for the late reply - but I'm still getting a message box saying "400". I've attached the workbook, please download it and take a look.

Thanks

Gausie

Fixed it!

The code that I was sent referred to cell 23 instead of 24!

My fault!

Gausie

Glad you got it sorted it out