This code was submitted as to how to paste into the first available row. If I wanted to transpose the paste and keep only the value and number format, where do I enter that into the code below?
(i.e.Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone...
Below is the current code, It works fine for the first line but I am unaware of how to specify the range that rather than being "A3:H3" it will copy the data from Sheet 2 "B2:B9" and insert into the next row. please help.
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 6/12/2007 by Anthony...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.