Add text to cells highlighted in rose
 

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!

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!

Add text to cells highlighted in rose
 

Gary"s Student,

It works! but I've just added text in some of those rose color cells.
How can I have a period and a space after the existing text and then have
"pre-LSA"
Ex: 80% cell. pre-LSA

I appreciate your help.

"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!

Add text to cells highlighted in rose
 

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!