Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP!!! I am unable to see colored text or highlighted cells ... | Excel Discussion (Misc queries) | |||
What can be done with highlighted cells? | Excel Discussion (Misc queries) | |||
Highlighted Text And/Or Cells | Excel Discussion (Misc queries) | |||
highlighted cells | Excel Discussion (Misc queries) | |||
Why aren't my cells highlighted when I select multiple cells? | Setting up and Configuration of Excel |