Copying data from an open workbook

[thedon_1]

I have some code that looks through my open workbooks, looks for a sheet called UK_3 and then copies the data from row 3 to the end and then pastes it into my current workbook, sheet1.

Unfortunately it doesn't actually select and copy the data. Any idea what's wrong?

Please Login or Register  to view this content.

Thanks

[Steffen Thomsen]

Hi

Try this change and se if it helps

Please Login or Register  to view this content.

[johncassell]

try selecting the workbook before attempting to copy so add this line in between your existing lines

Please Login or Register  to view this content.

[thedon_1]

From what i've read, ThisWorkbook selects the workbook running the macro. I've used the line in other things similar to this and it's been OK. I'm not 100% though so it may be that.

The thing is, the workbook in which I will be using the code will change so I don't really want to define the workbook name.

I tried defining the current books name and checking if it is the cause of the problem but it just does the same thing.

Any way around this?

[thedon_1]

try selecting the workbook before attempting to copy so add this line in between your existing lines

Please Login or Register  to view this content.

That seemed to do the trick, nice one!

[Steffen Thomsen]

Hi,

Try this sub instead.
This makes no selections and is faster.

Please Login or Register  to view this content.