it's OK, i found something that was very helpful.

http://www.mvps.org/dmcritchie/excel/saveas.htm


spences10 wrote:
Hi,

Does anybody know if there is a way to determine how much data is one
individual sheets in a workbook?

Something along these lines?

Sub CountWS()
Dim W As Worksheet

For Each W In Workbooks
W.Count
End Sub