| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Special Cell Selection
I have a nice macro that does some wonderful stuff. I want to take it a step
further, but I'm at a block. The next step is to take every cell that is highlighted in yellow and delete the values in them. What would a formula look like to plug into my macro? THANKS!!!!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Special Cell Selection
This looks for Yellow #6:
Sub gsnu() Dim r As Range For Each r In ActiveSheet.UsedRange If r.Interior.ColorIndex = 6 Then r.Value = 0 Next End Sub -- Gary's Student "bodhisatvaofboogie" wrote: I have a nice macro that does some wonderful stuff. I want to take it a step further, but I'm at a block. The next step is to take every cell that is highlighted in yellow and delete the values in them. What would a formula look like to plug into my macro? THANKS!!!!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| How flip a selection before pasting - Paste special | Excel Discussion (Misc queries) | |||
| In Excel: Paste Special should have a "Link Value" Selection | Excel Worksheet Functions | |||
| special cell selection | Excel Programming | |||
| Delete all special characters in a selection? | Excel Programming | |||
Linear Mode
