I need to know how to copy/pasta continuing down a column. For each time my macro adds in a new data row. My curgent macro copies five rows of data analysis formulas.
In my case column "K" is an array formula and keeps on erroring out.
Can someone show me a simple to do this.
for kicks why is it that arrays are different that they can't just be copy and pasted easily in via?
Arrays need to be entered pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula.
As to why this is not working for you...if it is not being entered using CSE, that is why
What exactly is teh formula, and why do you need a macro to copy it down, instrad of just copying it down in the normal way (using copy/paste or dragging)?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry about that.Originally Posted by FDibbins
The reason why I can't simply drag manually is that this spreadsheet is populated by a userform. This sheet remains very hidden. So I need automation for this
SAY THANKS
I DO THE SAME.
Try this:
Range("A1").FormulaArray = "=YOUR FORMULA HERE))"
Regards,
tt3
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks