Yaaay, first post! I have a workbook with about 40 sheet in it. I have created a macro to add a certain group of numbers in each of 650 rows . Then it adds the total from each row for a grand total. Is there a way to do this macro across all 35 sheets at one time? If I use ctrl to select all the sheets, The macro will not work correctly.