hello all, I have come across the macro below, this allows me to look at the cell(A10)
on all sheets in my workbook even new ones (except sheet1) and ad the contents of all sheets together
then put the total in A10 on sheet1, this works great BUT I want it to work over a lot of cells,
example A1...