HELP VBA Array Formula CSE (Ctrl+Shift+Enter)

deletedalien

Well-known Member
Joined
Dec 8, 2008
Messages
503
Office Version
2013
Platform
Windows
Can someone tell me why this line isnt working?

ActiveCell.FormulaArray = "=IFERROR(INDEX($C$2:$C$2000,SMALL(IF($F$372=$A$2:$A$2000,ROW($A$2:$A$2000)-ROW($B$2)+1),1)),"")"

i get "unable to set the formula array"

i know the formula works so... what gives???

im using this one on Excel 2010.

Thanx in advance.
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

lrobbo314

Well-known Member
Joined
Jul 14, 2008
Messages
2,758
Office Version
365, 2019, 2016
Platform
Windows
Try this,

Code:
ActiveCell.FormulaArray = "=IFERROR(INDEX($C$2:$C$2000,SMALL(IF($F$372=$A$2:$A$2000,ROW($A$2:$A$2000)-ROW($B$2)+1),1)),"""")"
 

deletedalien

Well-known Member
Joined
Dec 8, 2008
Messages
503
Office Version
2013
Platform
Windows
Try this,

Code:
ActiveCell.FormulaArray = "=IFERROR(INDEX($C$2:$C$2000,SMALL(IF($F$372=$A$2:$A$2000,ROW($A$2:$A$2000)-ROW($B$2)+1),1)),"""")"

That tottaly worked!!!!

thanx!
 

lrobbo314

Well-known Member
Joined
Jul 14, 2008
Messages
2,758
Office Version
365, 2019, 2016
Platform
Windows
No problemo. Quotes in VBA can be a pain.

───────────────────░█▓▓▓█░▇▆▅▄▃▂
──────────────────░█▓▓▓▓▓█░▇▆▅▄▃▂
─────────────────░█▓▓▓▓▓█░▇▆▅▄▃▂
──────────░░░───░█▓▓▓▓▓▓█░▇▆▅▄▃▂ ...
─────────░███░──░█▓▓▓▓▓█░▇▆▅▄▃▂
───────░██░░░██░█▓▓▓▓▓█░▇▆▅▄▃▂
──────░█░░█░░░░██▓▓▓▓▓█░▇▆▅▄▃▂
────░██░░█░░░░░░█▓▓▓▓█░▇▆▅▄▃▂
───░█░░░█░░░░░░░██▓▓▓█░▇▆▅▄▃▂
──░█░░░░█░░░░░░░░█▓▓▓█░▇▆▅▄▃▂
──░█░░░░░█░░░░░░░░█▓▓▓█░▇▆▅▄▃▂
──░█░░█░░░█░░░░░░░░█▓▓█░▇▆▅▄▃▂
─░█░░░█░░░░██░░░░░░█▓▓█░▇▆▅▄▃▂
─░█░░░░█░░░░░██░░░█▓▓▓█░▇▆▅▄▃▂
─░█░█░░░█░░░░░░███▓▓▓▓█░▇▆▅▄▃▂
░█░░░█░░░██░░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
░█░░░░█░░░░█████▓▓▓▓▓█░▇▆▅▄▃▂
░█░░░░░█░░░░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
░█░█░░░░██░░░░█▓▓▓▓▓█░▇▆▅▄▃▂
─░█░█░░░░░████▓▓▓▓██░▇▆▅▄▃▂
─░█░░█░░░░░░░█▓▓██▓█░▇▆▅▄▃▂
──░█░░██░░░██▓▓█▓▓▓█░▇▆▅▄▃▂
───░██░░███▓▓██▓█▓▓█░▇▆▅▄▃▂
────░██▓▓▓███▓▓▓█▓▓▓█░▇▆▅▄▃▂
──────░█▓▓▓▓▓▓▓▓█▓▓▓█░▇▆▅▄▃▂
──────░█▓▓▓▓▓▓▓▓▓▓▓▓▓█░▇▆▅▄▃▂
 

Watch MrExcel Video

Forum statistics

Threads
1,099,559
Messages
5,469,421
Members
406,650
Latest member
cc4digital2

This Week's Hot Topics

Top