ExcelBanter - View Single Post - Copy the same column from 50 sheets into a new sheet macro help!

[email protected]

wrote:

I tried that and it gave me all kinds of object and compile errors.
I assumed that the formatting got a little wonky in the c&p so I
tinkered around with it a bit, but it still seems to be fighting back.
;)

r

Hi,

You must naming workbook same like in formulaArray book1 ~ book50 too
with the same name of sheet1 in each workbook

Thanks,

Halim