tiredofit
Well-known Member
- Joined
- Apr 11, 2013
- Messages
- 1,834
- Office Version
- 365
- 2019
- Platform
- Windows
I have manually created an array formula which returns the correct results.
I need to adjust the range, so recorded a macro.
When I tried to run the macro, I got an error:
Could it be the formula is too long and complicated for VBA?
This is the formula:
[/FONT]
I need to adjust the range, so recorded a macro.
When I tried to run the macro, I got an error:
Rich (BB code):
Unable to set the FormulaArray property of the Range class
Could it be the formula is too long and complicated for VBA?
This is the formula:
Rich (BB code):
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]Selection.FormulaArray = _
"=IFERROR(IF(RC[-27]=""London"",MATCH(1,(VALUE(RIGHT(LondonData!R8C3:R286C3,9))=RC[-22])*(Start!RC[-2]=LondonData!R8C8:R286C8)*(Start!RC[-26]>LondonData!R8C1:R286C1),0),MATCH(1,(RC[-22]=Paris!R8C3:R29553C3)*(Start!RC[-2]=Paris!R8C4:R29553C4)*(Start!RC[-26]>Paris!R8C1:R29553C1),0)),""Missing"")"
[/FONT]