Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-17-2018, 12:57 PM
puff puff is offline How to express "or" in VBA? (code included) Windows 7 64bit How to express "or" in VBA? (code included) Office 2013
Advanced Beginner
How to express "or" in VBA? (code included)
 
Join Date: Apr 2017
Posts: 60
puff is on a distinguished road
Default How to express "or" in VBA? (code included)

Hi all. I have a document that has some empty lines start with "uppercase letter + ." like this:
2018-01-17_114845.png
Or simply start with "." like this:
2018-01-17_114818.png

My code so far can only remove the 2nd case


Code:
Sub DeleteLinesStartWith()

Dim oPara As Paragraph
Dim oRng As Range
Dim i As Integer
    For Each oPara In ActiveDocument.Paragraphs
        Set oRng = oPara.Range.Words(1)
        If LCase(Trim(oRng.Text)) = "." Then
            oPara.Range.Delete
        End If
    Next oPara
End Sub
1. The doc actually has other lines that I want to delete starting with some other signs, like "!". So how can I create a list/collection in the judging line for the macro?
If LCase(Trim(oRng.Text)) = "." Then

2. Some signs cannot be written in the VBA, like "•". In this case then, how can I delete an empty line start with "•"? Use the Unicode somehow?

Thank you very much.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
"Internet Connection Needed ... Error Code: 0-9" When Trying to use Online Repair millardjd Office 0 01-22-2015 07:54 AM
How to express "or" in VBA? (code included) How to get "Track Changes" to ignore "Field Code Changed"? Joey Cheung Word 2 10-31-2014 07:55 PM
Cross Reference Heading Number with the word "Section" included bblouin Word 5 12-20-2012 05:27 PM
How to express "or" in VBA? (code included) code "0020" appearing instead of space chracter in word docm, file radleyyeldar Word 1 07-30-2012 05:13 AM
How to express "or" in VBA? (code included) How to choose a "List" for certain "Heading" from "Modify" tool? Jamal NUMAN Word 2 07-03-2011 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:26 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