Add text to cells highlighted in rose
Sub by_any_other_name()
For Each r In Range("G2:G477")
If r.Interior.ColorIndex = 38 Then
r.Value = r.Value & "pre-LSA"
End If
Next
End Sub
--
Gary''s Student - gsnu200759
"Studebaker" wrote:
Can someone help with a variation of an earlier question I had? I want to add
text that says "pre-LSA" to every cell in G2 to G477 highlighted in rose
color.
I know part of what the Visual Basic code might be but not all of it.
Thanks!
|