You don't necessarily need a macro to do this if the worksheets are in the
same workbook. Try something like this:

=AVERAGE(Sheet1:Sheet3!A:A)
--
HTH,
Barb Reinhardt



"akapoor" wrote:

Hi,

I am working on large chunks of data spread across multiple spreadsheets.
I want to be able to run macros that treat data across these sheets as
contiguous.
eg. the avg() on column A should take into consideration all the values in
column A in all the spreadsheets.

Is this possible ?

Thanks in advance for your help!