Re: $$Excel-Macros$$ Need help with code to automate copy/paste

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

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

2012-04-16 Thread Erick C
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

Re: $$Excel-Macros$$ Need help with code to automate copy/paste

2012-04-16 Thread ashish koul
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

RE: $$Excel-Macros$$ Need help with code to automate copy/paste

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