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.
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.
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks