Applying macro to 'all opened files'

[Pedroluna]

Hi i have the following code:

I need that operation to be run on over 20 files. in the exact same cells and colunmns. I can insert the code in macro i already have for each file. But I rather just open all the files and then have this procedure applied to 'all opened files'. is that possible? and it is can i have the code?
Thank you

[mrice]

Try

Please Login or Register  to view this content.

I've assumed that you always want to work on the first sheet in the workbook.

[Pedroluna]

Martin, thank you.
you bring up a good point:'the sheet'. The sheet is the same in all files. it is name after the month of the year. So now i am working in the june files and i have done this operation in the June sheet of each file. Next month it will be the July sheet. How do i change the above code to pick the correct sheet?
Thanks again,

[mrice]

Please Login or Register  to view this content.

Try the above