Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
create search macro based on if cells are merged, or have color in
Hello all.
I would like to make a macro that looks for a specific property of a range of cells. It's typically a merged row, or a row with a color index. My thinking is as follows: Search for colorindex or merged row If cell colorindex != blank, application.run () fill down to next row where colorindex != blank (no color). And this is for Excel 2007. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically color merged cells | Excel Discussion (Misc queries) | |||
How to create a chart based on color percentage? | Charts and Charting in Excel | |||
How do I change a merged Cells background color | Excel Programming | |||
Create a macro to run autofilter based on contents of 2 cells | Excel Programming | |||
change fill color of a range of cells based on color of a cell? | Excel Programming |