Sorting Numbers in a Document

		Microsoft Office Forums > Microsoft Word > Word VBA
Sorting Numbers in a Document

01-04-2016, 06:14 PM

macropod

Windows 7 64bit Sorting Numbers in a Document

Office 2010 32bit

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,512

To delete duplicate rows, you could insert:

Code:

    For i = .Rows.Count To 2 Step -1
      If .Rows(i).Range.Text = .Rows(i - 1).Range.Text Then .Rows(i).Delete
    Next

after:
.Sort

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sorting Index According to Page Numbers	mohsen.amiri	Word	14	06-25-2015 09:50 PM
Sorting a mail merge by a specific number in the document	redzan	Mail Merge	4	05-17-2013 09:04 AM
How do I refer to page numbers, when the numbers change as I prepare the document?	StevenD	Word	5	11-29-2012 12:52 AM
Words in my document were converted to numbers????	MikeD23	Word	1	08-26-2012 11:09 AM
Sorting paragraph numbers	CommDude	Excel	1	01-02-2011 04:38 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 12:27 AM.