Delete Characters in a string

Hello Team,

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

Code

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

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

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.

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

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

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

Can I delete the text without affecting the formatting?

Quote:

---

Originally Posted by 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

---

If you use clear contents it should retain the formatting