Ignore my last question about how to add a space and period before "pre-LSA".
I wasn't thinking...I figured it out.
For anyone who wants to know:

r.Value = r.Value & ". pre-LSA"

Thanks. I'm trying to learn Visual Basic and you and the others are helping
a lot.



"Gary''s Student" wrote:

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!