Hello,
I am pretty new to Macro, and wondering whether someone on this forum can help me with this.
Please see the attached excel sheet, tab "Factor Template".
I need to copy range F5:I7 and paste for a specified number of times, i.e. 100 times, to the next available column with one column in between.
Please note that range F5:I7 includes both formulas and value.
Many thanks in advance!!
Hello MGuru. Try the following code. Please note that as the formulas are copied, the cell references will change. You may have to changes some or all of your formulas to absolute rather than relative references depending on what you want to do.
Please Login or Register to view this content.
Last edited by Mumps1; 01-09-2013 at 02:20 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks