Run-time error 13, Type Mismatch

  • Thread starter Thread starter T De Villiers
  • Start date Start date
T

T De Villiers

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace per VBA 4
MSGBOX Run-time Error '13': Type mismatch 6
Code Run-time Error '13 3
Run-Time error '13': Type mismatch 1
Run Time Error 13- Type mismatch 4
Type mismatch error - 'run-time error 13' 14
run time error 13 type mismatch 3
Run time error 13, type mismatch 7

Back
Top