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 SubOn Mon, Apr 16, 2012 at 9:51 PM, Rajan_Verma <rajanverma1...@gmail.com>wrote: > 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-macros@googlegroups.com > Subject: $$Excel-Macros$$ Need help with code to automate copy/paste > > Hi everybody! > I am hoping someone may be able to jelp me out. I am trying to write a > macro > that will take a formula that i write and copy it, move to the right seven > spaces, paste, move seven spaces again, paste, ect.. > Right now I need to have the formula pasted all of the way through column > AZZ. > Does anybody have anything made that I can tweak, or can anybody point me > in > a direction to find anything. I am quite the novice when it comes to > writing VBA from scratch, but I am sure I can get something going if I am > given something to start with. > Your help is appreciated!! > Thanks! Erick > > -- > 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 Advice > will > not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ---------------------------------------------------------------------------- > -------------------------- > To post to this group, send email to excel-macros@googlegroups.com > > -- > 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 Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* <http://www.accessvbamacros.com/> P Before printing, think about the environment. -- 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 Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
