Copy and pasting Array Formula via Macro

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

Range("M39").Select
 Application.CutCopyMode = False
 Selection.Copy
 Range("E23").Select
 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
 :=False, Transpose:=False

the array formula is here too:

=INDEX($L:$L,MAX((IF($L$22:$L$44=0,"",ROW($L$22:$L$44)))))

You could try

Range("E23").FormulaArray = Range("M39").FormulaArray

or to copy to a range

Range("E23:E28").FormulaArray = Range("M39").FormulaArray

Alf

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.

Tsk, tsk duplicate postings as well.

http://www.excelforum.com/excel-prog...via-macro.html

your action Arlette

Alf