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

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