Delete Characters in a string

[UmeshM]

Hello Team,

I am facing a similar problem as discussed in this thread . The error for me occurs at

Code
xlWB.Worksheets("Consistency_Check").Range("F" & colnum1).Characters(Start:=264, Length:=5).Text = ""

colnum1 = 17

I wish to delete the characters at this position.

Best Regards,
Umesh

[Bob Phillips]

You need to build a new string with the characters you wish to keep.

[UmeshM]

It did work for other ranges, but this particular range seem to throw the error. I tried the new string but it looses the formatting of the content.

[Bob Phillips]

So it does. I have never tried that but it surprised me.

What error are you getting, is the sheet name spelled correctly.

[UmeshM]

When I run the code though Word VBA it throws the Run time Error 1004

Adding test file along with this reply

I tried running this code in this excel
Worksheets("Sheet1").Range("A1").Characters(Start:=277, Length:=5).Text = ""

Result and Findings
Above code does not work on any content whose length is more than 250

[UmeshM]

Can I delete the text without affecting the formatting?

When I run the code though Word VBA it throws the Run time Error 1004

Adding test file along with this reply

I tried running this code in this excel
Worksheets("Sheet1").Range("A1").Characters(Start:=277, Length:=5).Text = ""

Result and Findings
Above code does not work on any content whose length is more than 250

[Aussiebear]

If you use clear contents it should retain the formatting