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
