In Cell A2 I have value J123, In Cell I2 I want S123
In VBA attempting to do this via:
Cells(2, 9) = Replace(Cells(2, 1), 1, 1, "S")
However getting Run-time error 13, Type Mismatch
Need to use this formula as doing this for hundreds of rows.
Many Thank
--
T De Villier
-----------------------------------------------------------------------
T De Villiers's Profile:
http://www.excelforum.com/member.php...fo&userid=2647
View this thread:
http://www.excelforum.com/showthread.php?threadid=56656