Macro to Copy Array Formula

I have an array formula in Col M2

I would like a macro to copy it down to the last row where there is data in Col A

It would be appreciated if someone could kindly amend my formula

Please Login or Register  to view this content.

Have you tried putting your data in a table? This makes copying formulas obsolete.

Originally Posted by flupsie

I have an array formula in Col M2

I would like a macro to copy it down to the last row where there is data in Col A

It would be appreciated if someone could kindly amend my formula

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Thanks for the help


When running the macro below, it returns #N/A. If I manually dray the Array from M2 downwards, It works perfectly. Once the formula has been dragged down, it can then be copied and paste as values to save memory


The formula is an array formula

Please Login or Register  to view this content.

Thanks for the reply. My data is not in a table