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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

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,644
Messages
5,469,895
Members
406,674
Latest member
melley

This Week's Hot Topics

Top