05-24-2019 10:45 AM
05-24-2019 10:58 AM
ok i didn't know such a function, but the following macro color all cells in selection with Line breaks.
Dim rngCell As Range
For Each rngCell In Selection
If InStr(rngCell.Text, vbLf) > 0 Then
rngCell.Interior.ColorIndex = 3
05-24-2019 06:51 PM
Thanks for the suggestions. Microsoft needs to make that an option like do in Word instead of me writing custom formulas to find these hidden items.
by umasirhc on July 29, 2020
by G_u_s_t_a_v on July 03, 2020
by Yigal Edery on April 26, 2017