how to use tab[column header] in VBA

[Tahitipit]

Hi,

I have the following formula in VBA which works fine
Worksheets("TRANSPORT").Range("ZONEFRET[Amount in local Currency]").Formula = "=IF(OR(B17="""",C17="""",D17="""",E17="""",F17=""""),"""",MIN(H17,MAX(C17*F17,G17)))"

But instead of using cell references I would lile to use tab[column header]

Here the fomula in excel format
=IF(OR(ZONEFRET[@Description]="",ZONEFRET[@QTY]="",ZONEFRET[@Unit]="",ZONEFRET[@Currency]="",ZONEFRET[@[Unite Price]]=""),"";MIN(ZONEFRET[@Max],MAX(ZONEFRET[@QTY]*ZONEFRET[@[Unite Price]],ZONEFRET[@Min])))

The syntaxe seems to be differente in VBA , how can I write that formula in VBA ?

Thanks

 

[jasonb75]

The macro recorder will give you the correct syntax.

Select any cell with the formula.
Start the macro recorder.
Press F2.
Press Enter.
Stop the macro recorder.

It should be as simple as doubling up on the double quotes, the same as you would with a regular formula
"=IF(OR(ZONEFRET[@Description]="""",ZONEFRET[@QTY]="""",ZONEFRET[@Unit]="""",ZONEFRET[@Currency]="""",ZONEFRET[@[Unite Price]]=""""),"""";MIN(ZONEFRET[@Max],MAX(ZONEFRET[@QTY]*ZONEFRET[@[Unite Price]],ZONEFRET[@Min])))"

But the single semi-colon in the formula is making me doubt that the formula syntax is valid.