Help to Highlight a cell that has less than 5 characters

Cendrinne · #1 11-08-2020, 07:37 PM

ahhhhhh yes I see, and I do get many cells. This type of work, I do have 5-10,000 Rows.
That is a very logical answer. Thank you

I even created a macro to find the next cell that starts with highlight.

and it works

Code:

Sub Find_Next_Start_Cell_w_Highlight()
'
'
    Selection.Find.ClearFormatting
    Selection.Find.Highlight = True
    With Selection.Find
        .Text = "<?"
        .Replacement.Text = ""
        .Forward = True
        .Wrap = wdFindAsk
        .Format = True
        .MatchCase = False
        .MatchWildcards = True
    End With
    Selection.Find.Execute
End Sub

Since I have so many rows, scrolling with the mouse makes my mouse scroller stop functionning, so this helps

I'm not a pro YET, but I do get better.

Thanks a million Paul

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Highlight only the characters ER when it occurs in SEVERE.	norgro	Word VBA	3	02-18-2013 05:14 PM
How to highlight the row based on cell value?	Learner7	Excel	1	12-11-2011 02:28 AM
Highlight the first X number of characters	14spar15	Word	1	11-13-2011 11:17 PM
find - reading highlight - highlight all / highlight doesn't stick when saved	bobk544	Word	3	04-15-2009 03:31 PM
highlight cell after checkbox	flatk	Word	0	01-25-2007 12:32 PM