Another problem with terminology. I presume you mean workbooks because
that was what was mentioned
before. The term spreadsheet is a bit ambiguous as to whether one
is referring to a workbook or a worksheet. I don't know how far back you
would have to go where you could have only one worksheet in a file.

Of course on paper a spreadsheet was one piece of paper because it
is not plural..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"sgrech" wrote in message
...

Hi David,
Thanks for your repsonse. I suppose I will just have to open the 30 or
so source spreadhseets.

Thanks
Simon


--
sgrech
------------------------------------------------------------------------
sgrech's Profile: http://www.excelforum.com/member.php...o&userid=14501
View this thread: http://www.excelforum.com/showthread...hreadid=529003