johanssson
New Member
- Joined
- Sep 27, 2013
- Messages
- 25
Hi all,
Have been stucked in a formula for hours now, cant really figure out what i'm doing wrong in this formula, maybe several mistakes by me or maybe something little hat i just missed:
Range("T" & rng.Row).Select
Selection.FormulaArray = "=IFERROR(INDEX(Tabell_Tidsrapport.accdb15[Effektiv tid E];MATCH(TidRapp_Expo!B28&TidRapp_Expo!K28;Tabell_Tidsrapport.accdb15[Date2]&Tabell_Tidsrapport.accdb15[Anställnings Nr:];0));"""")"
What it basically should do is to select the column T in my range.row and insert an arrayformula
Error message is :
Run Time Error '1004'
Unable to Set the FormulaArray Property of the Range Class
the formula itself works in the worksheet but i need to add it via a macro.
Have been stucked in a formula for hours now, cant really figure out what i'm doing wrong in this formula, maybe several mistakes by me or maybe something little hat i just missed:
Range("T" & rng.Row).Select
Selection.FormulaArray = "=IFERROR(INDEX(Tabell_Tidsrapport.accdb15[Effektiv tid E];MATCH(TidRapp_Expo!B28&TidRapp_Expo!K28;Tabell_Tidsrapport.accdb15[Date2]&Tabell_Tidsrapport.accdb15[Anställnings Nr:];0));"""")"
What it basically should do is to select the column T in my range.row and insert an arrayformula
Error message is :
Run Time Error '1004'
Unable to Set the FormulaArray Property of the Range Class
the formula itself works in the worksheet but i need to add it via a macro.
Last edited: