PDA

View Full Version : Grouping - VBA



Steve Belsch
01-10-2020, 10:59 AM
Hi VBA Experts,

I have attached a file with one tab as an example. The workbook I have developed has 265 worksheets. I have put this code into the macro:

Rows(J & ":" & i).Rows.Group

It works for each PO subtotals but I also need it to group rows 53-258. And the additional issue is that this range 53-258 will be different on all 265 tabs.

Any ideas?

Thank you.

Steve