I have spreadsheets that have subtotaled data. In order to quickly select the total rows I will collapse the data so that only the total rows are visible and then select the visible cells only. Since the data can be extensive, it may take several seconds to collapse the data.
I can perform the selection of visible cells in VBA and I can collapse the data in VBA but I want to avoid the wait if possible.
Is there a way to test in VBA if the data is collapsed so I can avoid the wait if it is?
Thanks in advance for any light you can shed on this question.
Jim