Delete the graph based on its character number

eduzs · #1 02-28-2018, 03:00 AM

You can try a VBA macro code like that:

Code:

Sub x()

Dim MyPara As Paragraph

For Each MyPara In ActiveDocument.Paragraphs
    If MyPara.Range.Characters.Count <= 4 Then MyPara.Range.Delete
Next MyPara

End Sub

Backup your original files before do any modifications or test, test before use, use at your own.

macropod · #2 03-12-2018, 04:55 PM

Quote:

Originally Posted by eduzs

You can try a VBA macro code like that:

A wildcard Find/Replace macro would be far faster - even a recorded one would be faster than your code.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
count a number of cells based on the beginning of a order number	Kubi	Excel	2	08-06-2017 08:54 PM
Delete Character on Single Line Only	Tye30	Word VBA	8	04-20-2017 08:40 PM
Delete starting number *) and delete Unneeded data in series	frustrated teacher	Word VBA	5	12-07-2014 06:53 PM
first character NOT Alpha numeric or Tilde (~) delete.	ksridh	Word VBA	5	03-17-2014 12:45 AM
graph changes number when losing embedded link	Alaska1	Excel	0	08-14-2013 11:31 AM