Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-15-2021, 01:12 AM
laith93 laith93 is offline Split function by comma and hyphen simultaneously Windows 10 Split function by comma and hyphen simultaneously Office 2019
Competent Performer
Split function by comma and hyphen simultaneously
 
Join Date: Jul 2021
Posts: 117
laith93 is on a distinguished road
Default Split function by comma and hyphen simultaneously

Hello, forums members,



I have this code to delete multiple pages

Code:
Sub DeleteMultiplePages()

'Delete Multiple Pages by displaying Inputbox

  Dim objRange As range
  Dim strPage As String
  Dim objDoc As Document
  Dim nSplitItem As Long

  Application.ScreenUpdating = False
 
  ' Initialize and enter page numbers of pages to be deleted.
  Set objDoc = ActiveDocument
  strPage = InputBox("Enter the page numbers of pages to be deleted: " & vbNewLine & _
            "use comma to separate numbers", "Delete Pages", "For example: 1,3")
  nSplitItem = UBound(Split(strPage, ","))

  ' Find specified pages and highlight their contents.
  For nSplitItem = nSplitItem To 0 Step -1
    With ActiveDocument
      Selection.GoTo What:=wdGoToPage, Which:=wdGoToAbsolute, Count:=Split(strPage, ",")(nSplitItem)
      Set objRange = .Bookmarks("\Page").range
      objRange.Delete
    End With
  Next nSplitItem
 
  Application.ScreenUpdating = True
End Sub
The code works fine, but my problem is that sometimes I want to delete continuous pages range in addition to a certain page, eg: 1-3,5,10-15. Hence, I want to use split function in the previous code: nSplitItem = UBound(Split(strPage, ",")) based on comma and hyphen eg: 1-3,5,10-15, or just comma eg: 1,5,9 or just hyphen eg: 1-10.

Thank you
Reply With Quote
 

Tags
word 19, word vba, word vba code



Similar Threads
Thread Thread Starter Forum Replies Last Post
Split function by comma and hyphen simultaneously Mistake in the help file for String "Split Function"? John 4 Word VBA 6 11-19-2020 06:02 AM
Hyphen until the end of the row abc3132 Word 13 10-31-2019 04:36 AM
Split function in Excel (split the screen) Officer_Bierschnitt Excel 1 07-05-2017 07:02 AM
Split function not working as I expect??!! XmisterIS Word VBA 9 04-08-2014 04:41 PM
Split function by comma and hyphen simultaneously Cross-reference function to update bullet header and number simultaneously dljenks Word 1 01-03-2014 01:38 PM

Other Forums: Access Forums

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