Cannot get macro button to sort with merged cells on sheet
Greetings. I have a button on the ‘Floodcoat Workup_Combos’ tab that auto sorts Column C (“Grade”) so that 200# E is on the bottom and 200# B is on the top. These are the only types of board grade that will be entered onto this sheet. However, the users using this sheet have requested a button to auto sort. I know they could simply using the filter option, but they are requesting a button. I got this to happen on the ‘Floodcoat Workup_Combos’ tab which I created, but on another tab that a coworker made (‘Floodcoat Workup_Single), I cannot get the button to work due to cells being merged & centered. Is there any way to get this button to work without messing with my coworker’s formatting? If you run into protection issues on anything I do not have a password at this time by the way.
Thank you all in advance.
|