Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 11-22-2025, 03:02 AM
RobiNew RobiNew is offline Macro to delete ending period at the end of a single paragraph Windows 11 Macro to delete ending period at the end of a single paragraph Office 2016
Competent Performer
Macro to delete ending period at the end of a single paragraph
 
Join Date: Sep 2023
Posts: 231
RobiNew is on a distinguished road
Default

Thank you for your time, Macropod!
In the following macro the line "oPar.Range.Characters.Last.Previous = vbNullString" returns this error "object doesn't support this property or method". Can you help?
Code:
Sub RemovePeriod()
  Set oRng = ActiveDocument.Range
For Each oPar In oRng.Paragraphs
  If oPar.Range.Style = "LeftTitle" Then
  'MsgBox "Found"
  If oPar.Range.Characters.Last.Previous = "." Then
  'MsgBox oPar.Range.Characters.Last.Previous
  oPar.Range.Characters.Last.Previous = vbNullString
  End If
  End If
Next oPar
End Sub
Reply With Quote
 

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro to delete ending period at the end of a single paragraph Macro to delete table rows based on the absence of a single specific keyword JellehFishh Word VBA 2 06-27-2019 08:23 AM
Highlighting applied to range ending in a paragraph continues to apply to text added after Peterson Word VBA 2 10-08-2018 02:50 PM
Delete starting and ending character of a line Ktulu Word VBA 2 04-26-2018 09:59 AM
Macro to delete ending period at the end of a single paragraph how do you formulate the date by pay period ending? crussell Excel 8 02-23-2016 07:38 AM
Paragraph ending in following page tadlomc Word 1 01-18-2012 05:31 AM

Other Forums: Access Forums

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


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