Using Find() in VBA

[Nike6106]

Hi

I use the find function alot in my spreadsheets.
For example if I have "2x3" in cell A1 and write the function =find("x",A1) excel will return 2. I am trying to use this in VBA but I am getting Sub or Function not defined, guess it is interferring with the VBA find function.

Any idea how I can get the location of the "x" in the string?

Thanks

[StephenR]

MsgBox WorksheetFunction.Find("x", Range("A1"))

works for me.