I am trying to copy and paste an array formula via a macro. It doesn't come up with a error message, it just doesnt copy the forumla into the relevant cell even though it displays it in the macro. any help? the macro is below
Please Login or Register to view this content.
the array formula is here too:
=INDEX($L:$L,MAX((IF($L$22:$L$44=0,"",ROW($L$22:$L$44)))))
Last edited by arlu1201; 02-05-2013 at 11:22 AM.
You could try
or to copy to a rangePlease Login or Register to view this content.
AlfPlease Login or Register to view this content.
Last edited by Alf; 02-05-2013 at 11:22 AM.
Welcome to the forum.
I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. If you need more information on how to use them, check my signature below this post.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Tsk, tsk duplicate postings as well.
http://www.excelforum.com/excel-prog...via-macro.html
your action Arlette
Alf
Last edited by Alf; 02-05-2013 at 11:38 AM.
I am having another problem, when i insert - Range("E23").FormulaArray = Range("M39").FormulaArray - it copies the formula and not the value. This then changes all the other values that is inserted into a table. Is there any chance of just pasting the values to the cell e23 within a macro?
I think you got what you asked for in your first post.I am trying to copy and paste an array formula via a macro.
If you only wish to copy the value you was on the right track with your macro but you don't need to use the "Select" command.
This should be sufficient:
AlfPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks