or UN tested
Sub Macro1()’adjust your destination range azz1
dim I as long
For i = 9 To Range("azz1").Column step 7
Range("A1").Copy Cells(1, i)
Next
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
[email protected]
From: ashish koul
Sent: Monday, April 16, 2012 11:26 AM
To: [email protected]
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 <[email protected]> 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: [email protected] [mailto:[email protected]]
On Behalf Of Erick C
Sent: Apr/Mon/2012 09:43
To: [email protected]
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 [email protected]
--
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 [email protected]
--
Regards
Ashish Koul
http://www.excelvbamacros.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 [email protected]
--
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 [email protected]
