Loop Macro that copys from various files until blank cell

[luke11111]

I am still new to VBA code and am hoping someone out there can help me.

I need a macro that can loop through files(various names) in a single folder, copy data from worksheet (calculations) to origin workbook sheet (Workings), stop copying range when it reaches a blank cell, close files.

Basically each file has a range of data that is dynamic and could be different sizes. I need to copy that data into the workings tab but NOT the blanks.

I have been working on a bit of code but it doesnt work and keeps giving me a Out of Memory error.

Please Login or Register  to view this content.

Thanks to anyone who can help.
Happy to abandon my poor attempt at code if anyone can do better.

[Marc L]

Hi !

The issue may be the code workbook saved as .xlsm in same folder than source workbooks .xlsm !
Move code workbook to another directory or if it needs to stay in place save it as a binary workbook .xlsb
then delete original .xlsm one. And separator directory is "\" …