Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 08-17-2023, 12:44 PM
Onjai Onjai is offline VBA to cut colored text from one document and paste to another Windows 10 VBA to cut colored text from one document and paste to another Office 2016
Novice
VBA to cut colored text from one document and paste to another
 
Join Date: Aug 2023
Posts: 6
Onjai is on a distinguished road
Default VBA to cut colored text from one document and paste to another

Hi,
Document contains this text:


1 Now a Green Text 2 Label this in Black
3 Soft Kitty
4 Dog owners are great.
5 Spelling is not my forte
6 Measure Twice
7 Distance Measure


The following code will find 1st instance of the yellow text and Cut/Paste it to a new document. On the second loop it crashes at Selection.Range.Paste with Object empty error.
Not sure what the issue is. Likely that I am quite new to VBA and Word docs. Any help would be appreciated.



Sub FindYellowText()

Dim oResponse As Document

Selection.HomeKey wdStory
With Selection.Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = ""
.MatchWildcards = False
.Forward = True
.Wrap = wdFindStop
.Font.ColorIndex = wdYellow
.Execute

Do Until Not .Found
If Selection.Range.Font.ColorIndex = wdYellow Then
Selection.Range.Cut
Set oResponse = Documents.Add
With oResponse
Selection.Range.Paste


End With
End If
.Execute
Loop

End With
End Sub





Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to cut colored text from one document and paste to another Copy selected text from one document and paste to new document in same position on the page gasparik Word VBA 1 05-11-2020 05:41 AM
VBA to cut colored text from one document and paste to another Why do pages 10-24 disappear when I type in more text on page 2 or paste new text into the document? RET Word 1 05-02-2016 07:28 PM
VBA to cut colored text from one document and paste to another colored background to text userman Word 2 09-26-2012 01:52 AM
not showing colored text from external emails MasterGator Outlook 0 01-31-2012 02:20 PM
Making text boxes with colored bar at the top daviddoria PowerPoint 0 08-30-2009 03:19 PM

Other Forums: Access Forums

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