Assign entire row to variable, how do you paste variable values in a new workbook?

Syntax is killing me and I've been searching for a solution and can't find a thing. Or maybe it's just too late in the evening/early morning to have Excel VBA on the mind?!

As the title says, I'm assigning an entire row of data to a variable via the following:

Please Login or Register  to view this content.

How do I paste the values stored in myRow say in Row 12 on another workbook. Up until now I have dealt with rows directly that are not assigned to variables. I'm sure it's simple... maybe my head is foggy?!

Thanks

Kaper,

That is so simple and yet seems convoluted to my brain right now. Thanks for clearing that up for me.

One further question, how would you apply a paste special so as to control format of the pasted cells?

Thanks very much,

TV

If you want to deal with formating it is pobably wiser use clipboard. So the sequence could be :

Please Login or Register  to view this content.

Or you could do the same this a range object:

Please Login or Register  to view this content.

Ah, I see now. So clipboard is the way to go and that's where PasteSpecial comes in. I would never have thought you could use myRow.copy.

Thanks again for clearing that up for me.

Cheers,

TV