Sort sheet when option button selected

I am trying to sort a sheet when a option button is selected, the code works fine when run on the sheet but it bugs out on the first line when the option button is selected.

I have attached a workbook showing what is happening.

Thanks for any advice.

Please Login or Register  to view this content.

Hi

Your code is over complicated.

But I have amended it for you.

You should really be using a command button for this. I have added one for you.

Please Login or Register  to view this content.

thanks Fotis that seems to be working fine, just one other question, as the sheet that will be sorted will be hidden when I tested it it bugged out on the first line, what do I have to do to modify the code to sort the sheet when hidden.

Thanks again.

Thank you Fotis I will mark this as solved.