0

I have this formula in excel Range("M4:M" & Lastrow) = "=(PRODUCT((INDEX('Database'!$F:$F,MATCH(AD4&$D$2,'Database'!$B:$B&'Database'!$A:$A,0)+11):INDEX('Database'!$F:$F,MATCH(AD4&$D$2,'Database'!$B:$B&'Database'!$A:$A,0)))/100+1)-1)*100" but when I put in in vba it adds @ in front of some of the references, would you know the syntax of this formula for VBA ?

this is the result applying the formula from VBA.

=(PRODUCT((@INDEX('Composite Database'!$F:$F,MATCH(AD4&$D$2,@'Composite Database'!$B:$B&@'Composite Database'!$A:$A,0)+11):INDEX('Composite Database'!$F:$F,MATCH(AD4&$D$2,@'Composite Database'!$B:$B&@'Composite Database'!$A:$A,0)))/100+1)-1)*100

Many thanks for your help,

Nev

Tried to use range().value instead but i have a type mismatch despite each criteria working individually.

FaneDuru
  • 38,298
  • 4
  • 19
  • 27
nevi.11
  • 1
  • Please, try `Range("M4:M" & Lastrow).Formula2 = "=(PRODUCT((INDEX('Database'!$F:$F,MATCH(AD4&$D$2,'Database'!$B:$B&'Database'!$A:$A,0)+11):INDEX('Database'!$F:$F,MATCH(AD4&$D$2,'Database'!$B:$B&'Database'!$A:$A,0)))/100+1)-1)*100"` – FaneDuru Mar 31 '23 at 08:37

0 Answers0