![]() |
|
#1
|
||||
|
||||
![]()
Try this version
Code:
Sub DeleteMultiplePagessssssssssssss() 'Delete Multiple Pages by displaying Inputbox Dim objRange As Range, strPage As String, objDoc As Document, nSplitItem() As String, iCounter As Integer 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") strPage = funExpandDashes(strPage) nSplitItem = Split(strPage, ",") ' Find specified pages and highlight their contents. For iCounter = UBound(nSplitItem) To 0 Step -1 With objDoc Selection.GoTo What:=wdGoToPage, Which:=wdGoToAbsolute, Count:=nSplitItem(iCounter) Set objRange = .Bookmarks("\Page").Range objRange.Delete End With Next iCounter Application.ScreenUpdating = True End Sub Function funExpandDashes(strPage As String) As String Dim arrOuter() As String, iMin As Integer, iMax As Integer, arrInner() As String, sExpand As String Dim x As Integer, y As Integer strPage = Replace(strPage, " ", "") 'make sure there are no spaces arrOuter = Split(strPage, ",") For x = LBound(arrOuter) To UBound(arrOuter) arrInner = Split(arrOuter(x), "-") If UBound(arrInner) > LBound(arrInner) Then sExpand = arrInner(0) For y = CInt(arrInner(0)) + 1 To CInt(arrInner(1)) sExpand = sExpand & "," & y Next y arrOuter(x) = sExpand End If Next x funExpandDashes = Join(arrOuter, ",") End Function
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#2
|
|||
|
|||
![]()
Fantastic,
Thank you so much, Mr. Andrew, the code works fine. Just I want to increase my info in VBA, why we used this line again Code:
nSplitItem = Split(strPage, ",") Can you explain as you can, otherwise ignore it. Thank you again |
![]() |
Tags |
word 19, word vba, word vba code |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
dljenks | Word | 1 | 01-03-2014 01:38 PM |