Forum Discussion
Lorenzo Kim
May 19, 2018Bronze Contributor
command button suddenly does not function
I have created 2 command buttons for materials usage - the first button deletes rows with cell G=0, sorts then subtotaled them; the second button - updates/refreshes the file. After the first butto...
Matt Mickle
May 21, 2018Bronze Contributor
Lorenzo-
Based on some tests I just did it appears that sort does not work on grouped data. I'm guessing this is intentional as to not rearrange the grouping hierarchy. So when your code executes, the lines of code are being run but the application just ignores them or applies them to the cells in your range that are not grouped together.
Lorenzo Kim
May 21, 2018Bronze Contributor
Thank you