Re: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently

2012-04-27 Thread dguillett1
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

RE: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently

2012-04-27 Thread Rajan_Verma
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

Re: $$Excel-Macros$$ Pls help me brothers, need macro - Urgently

2012-04-27 Thread LAKSHMAN PRASAD
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