Change activate workbook to be vba created workbook

Hey folks

Got stuck in this one and hope someone can help me out.

I create a workbook by vba and my problem is simply that I cannot change the new workbook to be the activeworkbook where i can select cells and so fourth. I can insert values in cells in the new workbook, but as I need to copy cells from the original workbook to the new one and further manipulate the data, I need to be able to select cells in the new wb. Thanks in advance for your help! Code is following:

Please Login or Register  to view this content.

Try this

Please Login or Register  to view this content.

In order to do copy and pasting you'll have to activate the original sheet copy the information then reactivate the new workbook to tell it where to paste it.

Perfect! Just what im looking for. Thanks a lot!

AlvaroSiza: You're right that it's possible to copy and paste across the two wb's, but the problem is that I would quickly run into limitations if I couldnt activate the new wb (e.g. range selection with End(xl..)). But thanks ! (:

TMShucks: I have no doubt that you are right, but I dont see how you would be able to define the NewWB if it is never the ActiveWorkbook? The copying and last row determination in your post both depends on NewWB to be defined, which was not possible in my initial macro in post #1. Or am I missing something?

Aha I see. Thanks for the explanation! It certainly made things clearer