You finish
Option Explicit
Sub transposeqmSAS()
'fire from qmform sheet
Dim dlr As Long
With Sheets("raw")
dlr = .Cells(Rows.Count, "b").End(xlUp).Row + 1
Range("C4:C40").Copy
Sheets("Raw").Cells(dlr, "b").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=True
R
Hi,
How many worksheet of QM Form do you have ?
Rajan
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mukesh Kukreja
Sent: Apr/Fri/2012 03:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently
why need macros? use paste as transpose only.
From: Mukesh Kukreja
To: excel-macros@googlegroups.com
Sent: Friday, April 27, 2012 3:29 PM
Subject: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently
Hi All,
Request you to kindly help me very u