I understand when working in Excel, I can select multiple sheets as a group and then apply changes to the first sheet and those same changes will be reflected in all sheets of the group. I would like some help in doing this same thing using VBA. I have attached a workbook that I hope you can use to help me understand the way to work with sheets in an array. If I enter the following code
I am able to select all the sheets. I want to insert rows at the same location across all the sheets. But if I use
The row is inserted on the January Sheet only. Please let me know how I need to change that code in order to apply that same insert of the row on all sheets that have been selected in the array.
The info I am working with looks like a table but is not formatted as a table. I won't be able to go back and format it as a table and I need to make sure that the formulas and conditional formatting applied to each row are copied into the newly inserted row as well.
Thanks for any insight you can provide