16, 2012 11:26 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Need help with code to automate copy/paste
try something like this
On Mon, Apr 16, 2012 at 9:51 PM, Rajan_Verma wrote:
Hi Erick,
I Will glad to help but can you please explain more what you actually want?
I m
Hi Ashish,
Thank you, your suggestion works perfectly! Thanls again for the prompt
response!
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advic
try something like this
Sub Macro1()
' suppose ur forumula is in a1
Range("A1").Copy
For i = 9 To Range("azz1").Column
Cells(1, i).Select
Selection.PasteSpecial Paste:=xlPasteFormulas
i = i + 7
Next
End Sub
On Mon, Apr 16, 2012 at 9:51 PM, Rajan_Verma wrote:
> Hi Erick,
> I Will glad to help but
Hi Erick,
I Will glad to help but can you please explain more what you actually want?
I mean what will be the input and output.?
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Erick C
Sent: Apr/Mon/2012 09:43
To: excel-mac