Hi There!

I have a report that sum up all values from all sheets within a
workbook, the formula is like these ='Sheet1:Shee2'!A9, i copied it
up to column Z to summarize all the values.

My question, can I create a macro that can check if all my data's from
all sheets starts in row9 excluding the column heading which starts in
row8?


Thanks in Advance! Have a nice day!


Jerome