Hi All,

You've all been most helpful in the past...

I am running a macro in a 'Host' workbook. I am copying data from a 'Source' workbook.

The macro opens the latest workbook in a folder (source) and copy data back across to the host before closing the source book.

I am only copying A:A from the source book and the numerical data is all either 7 digits or lower.

I only want to copy cells which are less than 7 digits and paste them neatly back into the host worksheet. I'm nearly there but I'm stuck on the code to do it slickly.

Can anyone help possibly?

Many thanks in advance!

Guy