Hi
try replacing
A4
with
Range("A4")

--
Regards
Frank Kabel
Frankfurt, Germany

"Kevin" schrieb im Newsbeitrag
...
Hi i am having trouble putting this formula in my code any idea where
i have gone wrong?

Cells(intRowCount + 1, 4) =
WorksheetFunction.Substitute(Substitute(A4, "Total Amount - ", ""), "
USD [Mln]", "") * 1

Pls help