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
Th
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, 1).R
Wednesday, March 14, 2012 3:01 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Macro for format table
Hi
Thank u very much.I need some change in the code.
here I want to count the number of cells deleted in column B here 25 cells
In column C delete 50 cells
In column D delete 7
xlDown).Row
> lr = Cells(Rows.Count, i).End(xlUp).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
> Se
, 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 experts
Find the attac
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