Microsoft Office Forums - View Single Post - [Solved] Help to Highlight a cell that has less than 5 characters

Cendrinne · 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