| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Didn't mean to be vague about the code: here's an example of code to
look in each cell, and un-shade a cell that is currently yellow: Sub Find_Yellow() Dim rCell As Range For Each rCell In ActiveSheet.UsedRange If rCell.Interior.ColorIndex = 6 Then rCell.Interior.ColorIndex = 0 Next rCell End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| document prints shifted to the right like it is right justified. | Excel Discussion (Misc queries) | |||
| How to embed Word document into Excel and retain sizing, formatti. | Excel Discussion (Misc queries) | |||
| Help, insert a word document contents into excel tab? | Excel Discussion (Misc queries) | |||
| Hyperlink to a word document | Excel Discussion (Misc queries) | |||
| Hyperlink to word document problem | Links and Linking in Excel | |||
Hybrid Mode
