Hi there.
Why cant i do this?
I am tring to place a formula in cell B based on the result of cell A but i also need to substitue the "/" from cell A too.
I thought the above would seem logical - but - it gives me a compile error.
Any suggestions please?
Thanks a million in advance...
Why cant i do this?
If c <> "" Then c.Offset(, 1).Formula = "=MT4|BID!" & Substitute(c, "/", "") & "m"
I am tring to place a formula in cell B based on the result of cell A but i also need to substitue the "/" from cell A too.
I thought the above would seem logical - but - it gives me a compile error.
Any suggestions please?
Thanks a million in advance...