Windows 7 Copy and Paste macro

Microsoft Office 2007 home and student
February 25, 2010 at 03:25:13
Specs: Windows 7
Can anyone help me?
I have a macro that copies and pastes one piece of data at a time
Sub PasteText()
ActiveSheet.PasteSpecial Format:="Text", Link:=False, _
DisplayAsIcon:=False
End Sub
But I wish to use a macro that will copy multiple pieces of data (can vary from 2 to 20 pieces) then paste on Microsoft office Excel starting from different locations down columb G with 8 rows separating each piece of data
Thanks.

See More: Windows 7 Copy and Paste macro

Report •

#1
February 25, 2010 at 08:48:07
Your question is probably best asked in the Office Software forum.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question