Thread
:
Macro to remove table captions leaves empty space
View Single Post
08-05-2019, 01:12 AM
Guessed
Windows 10
Office 2016
Expert
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
A paragraph range always includes a paragraph mark so Range.Text is going to give you a vbCr value. Try looking for aRng.Paragraphs(1).Previous.Range.Text = vbCr
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Guessed
View Public Profile
Visit Guessed's homepage!
Find all posts by Guessed