try this

Range("A1").Formula = "=Match(" & ccy & ", A:A, 0)"

--


Gary Keramidas
Excel 2003


"diepvic" wrote in message
...
I need to assign a formula for cell A1 as below:
Range("A1") .formula = "=Match(""USD"", A:A, 0)"

However, the lookup_value (USD) is a variable, named Ccy (currency). How
should I change the code above to replace the USD with the variable Ccy?

Many thanks!