Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selection by color
Hi I have a programming problem I just cant seem to solve.Most times I can cobble together enough code to do what I need But this I cant do. Below is what Im trying to do If anyone can help I surely will appreciate it. Im running Excel XP (2002) on Windows XP Home Edition.I have 9 colums(A Thru I ) and 1000 rows of numbers On Sheet 1 there is a emty row between every seven rows.I need to check the first Seven Rows of Col A Sheet 1 If the Cells InteriorColor Index=4 Select CurrentRegion Of Active Cell Which Will Be (a1:i 7),Copy and past into sheet 1 next empty row of workbook 500. There may be more than one green cell or there may not be any Green Cells In Each of the Seven Rows.when that's all done I need to the next seven rows Of Col A(Which will be(a9:i15) and do the same as above etc until Col G cell is greater than 1000 Then Stop.I have One blank Row Beteween each Seven Rows To enable the CurrentRegion Selection . I suppose this is about as clear as mud but at least it's a starting point I be glad to try clear up anything that's not clear to anyone who will help Me Thanks Tinkerbell |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change selection color | Excel Discussion (Misc queries) | |||
Getting color of each cell in selection | Excel Programming | |||
Getting the color for each cell in a selection | Excel Programming | |||
selection.font.color returns wrong color; the first execution | Excel Programming | |||
Color of selection in combo box | Excel Programming |