Thanks Barb,

I tried this macro on one test file in one folder. However the macro
execution never stops. It keeps on executing and I need to interrupt it. I
think it keeps on opening the same workbook again and again. I tried to debug
but could not... :(

Regards,
prm

"Barb Reinhardt" wrote:

If you want to loop through all worksheets in the opened workbook, change the

Set oWS = ... to

for each oWS in oWB.Worksheet

next oWS

And put all the action on oWS in that loop


"Pawan" wrote:

Hello

I have a folder with several excel files in it. I want to write a macro in
new workbook. This macro should count the number of used 'unique' cells from
column "A" of all the excel sheets. The result should be added in one sheet
of the book (in which macro is written).

Thank You

Regards,
prm