Dear Experts,
My macro is able to copy the data as per the VBA code. The code for the copy destination is not working. Need your support on this.
Expected Action: From sheet "List" copy the each row and paste it in the sheet 2 paste special & Transpose until last row in sheet"List".
Thanks in Advance
Try this,
But, you should not be using selection in your code
Range(Selection, Selection.End(xlToRight)).Copy Sheets("Sheet2").Range("a22").PasteSpecial Paste:=xlValues, Transpose:=True
Last edited by JapanDave; 07-21-2013 at 06:30 PM. Reason: I watched Tinkerbell.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Dave,
Will that be my homework or course work?
Yep, But at least I will will reply back to you..Originally Posted by AB33
Dave,
It is sunny out here. I am up for water sports and Beers. I would not able to do my work until the sun disappears.
The SUN is too precious and becoming in an dangerous species in this part of the world. So, the cliché is "Enjoy while it lasts"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks