Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-08-2022, 02:59 AM
Cendrinne's Avatar
Cendrinne Cendrinne is offline Help, to Select all Rows with color Orange...... Windows 10 Help, to Select all Rows with color Orange...... Office 2019
Competent Performer
Help, to Select all Rows with color Orange......
 
Join Date: Aug 2019
Location: Montreal Quebec Canada
Posts: 200
Cendrinne is on a distinguished road
Default Help, to Select all Rows with color Orange......

Hello Pros,
I don't seem to have figured out, how to Select All Rows with the color Orange **Fonts**.
If found, then Convert To Text Separator:=wdSeparateByParagraphs for 1 Table and All Tables.

I figure out how to do it for the next Row, but once splited, it won't go back to the table. It doesn't have to find the next row, just select all rows with orange color then Convert to text. It will be many rows in a row, Either, at the start of a table or at the end of a table.

I've tried to find any Character, But at times, I have a row that is empty that is color Orange. How to convert to text or Paragraph mark on those too? Unless it's not doable.



[CODES] Dim aTbl As Table

Set aTbl = ActiveDocument.Tables(1)

Selection.Find.ClearFormatting
Selection.Find.Font.Color = wdColorOrange
With Selection.Find
.Text = "^?"
.Replacement.Text = ""
.Forward = True
.Wrap = wdFindStop
.Format = True
.MatchCase = True
.MatchWildcards = False
End With
Selection.Find.Execute
Selection.SelectRow
'Selection.SplitTable
Selection.Rows.ConvertToText Separator:=wdSeparateByParagraphs, _
NestedTables:=False

On Error GoTo 0
[/CODES]

My idea is to keep only the rows I want to keep in a table, but Convert the Column Titles to text.

Is that even possible?
Tried to find it on the web, then trial and error, and recored steps, I'm closer to the step I want but can't find the solution.

I thank you in advance

Cendrinne

Last edited by Cendrinne; 02-08-2022 at 07:07 PM.
Reply With Quote
Reply

Tags
help please, select rows font color



Similar Threads
Thread Thread Starter Forum Replies Last Post
5000 rows, want to select and perform addition on ever 48 rows Rexmaverick Excel 5 06-10-2019 06:29 AM
Need to apply Heading1 to select rows bobk544 Word VBA 3 06-09-2018 05:24 AM
Help, to Select all Rows with color Orange...... Select color palette using vba Catty Word VBA 3 10-08-2015 09:32 PM
Help, to Select all Rows with color Orange...... Orange + Outlook 2010 office_ju Outlook 3 10-16-2014 05:53 AM
Help, to Select all Rows with color Orange...... Select text by color Invain Word 1 02-14-2010 07:08 AM

Other Forums: Access Forums

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