Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-16-2021, 04:25 PM
Guessed's Avatar
Guessed Guessed is offline Reverse Paragraph List Macro Windows 10 Reverse Paragraph List Macro Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,166
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default


I think the message box at the start needs to be a bit more complex to deal with the likely selections: less than two paragraphs; includes a table
Code:
Sub ReverseOrderOfParagraphs()
  Dim tmpTable As Table, rg As Range
  
  If Selection.Range.Paragraphs.Count < 2 Then
    MsgBox "You must select more than one paragraph"
    Exit Sub
  ElseIf Selection.Range.Tables.Count > 0 Then
    MsgBox "This macro doesn't work with selections which are in tables"
    Exit Sub
  End If
  
  Set tmpTable = Selection.Range.ConvertToTable(Separator:=wdSeparateByParagraphs)
  With tmpTable
    .Columns.Add BeforeColumn:=.Columns(1)
    
    Set rg = .Cell(1, 1).Range
    rg.End = rg.End - 1
    rg.Fields.Add Range:=rg, Type:=wdFieldSequence, Text:="a"
    rg.Cells(1).Range.Copy
    
    .Columns(1).Select
    Selection.Paste
    Selection.Fields.Update
    
    .Sort ExcludeHeader:=False, FieldNumber:=1, SortOrder:=wdSortOrderDescending
    .Columns(1).Delete
    .ConvertToText
  End With
End Sub
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
How Do I Control Paragraph Spacing in a Numbered List SteveClark590 Word 11 07-08-2021 07:31 PM
How do I order the paragraph styles list? Tunathedog Word 3 04-08-2016 05:37 AM
Reverse Paragraph List Macro Reverse Bold macro brent chadwick Word VBA 15 02-26-2016 05:25 PM
Reverse Paragraph List Macro Is There an Animation that Will Reverse the Order of a Bulleted List equity PowerPoint 3 04-04-2014 12:33 AM
Macro to reverse a test string Jennifer Murphy Word VBA 5 01-16-2014 03:19 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft