Add text to cells highlighted in rose

  • Thread starter Thread starter Studebaker
  • Start date Start date
S

Studebaker

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

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top