I don't understand your need and WHY
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh K R
Sent: Thursday, March 15, 2012 12:16 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for format table
Hi
Thank u
).Row
Cells(fr, i).Resize(lr).Copy Cells(2, i + 6)
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh K R
Sent: Tuesday, March 13, 2012 8:50 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro for format table
Hi
Thank u for ur reply, still I need some more changes in the code, pls
check the attached xl file, it will show step by step what to do.pls
make the necessary change in the code for getting the result.
Sub CopyColumnsToTableSAS()
Dim i As Integer
Dim fr As Long
Dim lr As Long
'col A
Cells(2,
Hi experts
Find the attached file,and help me to create a macro to format a table
from the data given.
My idea to solve this
select column A:E, paste in G1
Select blank cells in column B ,here B2:B26 Deletethem
Repeat the sale in next columns
Regards
Rajesh Kainikkara
--
FORUM
Cells(2, i + 6)
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: Rajesh K R
Sent: Tuesday, March 13, 2012 8:50 AM
To: excel-macros
Subject: $$Excel-Macros$$ Macro for format table
Hi experts
Find the attached file,and help me