Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Cell Interior Colour of First Cell in Column
I have a column with data in it. The column grows over
time during a sub routine (i.e. it get longer) I want to pass the first cells (say A1) interior colour to a variable. However none of the cells in the column are named except the most recent addition (say A30). I want to be able to take the named cell extract from that the first cell in that columns address. Similar to doing an xlUp from the named cell. Is the xlUP the only way I can do this. And if so, what do I do after the xlUp to actuallly select the first cell. I was hoping I could do this without selecting cells. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding last occurence of Interior.ColorIndex 36 | New Users to Excel | |||
Cell interior color | Excel Discussion (Misc queries) | |||
Code to change interior colour only if current interior colour is | Excel Programming | |||
Conditional Format with VBA - Interior Colour of cell based on value from in-cell dropdown | Excel Programming | |||
Interior Cell color | Excel Programming |