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.
Extra Credit
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
Bookmarks