Mix relative & absolute reference in VBA code formula ?

[jgun84]

hey,

need your expertise guys, i have a formula for VBA code below. it returns an error

Sub test()
Range("Y17").Select




ActiveCell.FormulaR1C1 = "=IF(MAX(RC[2]:RC[14])<=0,""-"",INDEX($AA$15:$AM$15,0,MATCH(MAX(RC[2]:RC[14]),RC[2]:RC[14])))"""
End Sub

I believe the absolute reference causes an error. appreciate your help

Regards,
Jack G

 

[steve the fish]

Re: Help - how to mix relative & absolute reference in VBA code formula ?

Hi. Do you know how to use the macro recorder? Record putting the formula in the cell. Dont forget the absolution. It will give you exactly what you ask for.

 

[jgun84]

Re: Help - how to mix relative & absolute reference in VBA code formula ?

Steve the fish - thanks for prompt reply. Problem solved !