What VBA code would I use to add all sheets in a workbook to an array EXCEPT "Sheet1" ??
The sheet names will change but "sheet1" will always stay the same.
After getting them added to the array , I want to sum Column E in Cell F1...
This shold be very simple macro to do this but I am not sure how to get started by selecting all the sheets EXCEPT sheet1
Sheet 1 has all my data, and a macro creates approx 50 other sheets all named differently with respect to the data in sheet1. I then just need to Sum column E for all 50 sheets.
Bookmarks