Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I need an if statement that looks at a specific field and checks to se if it is white. I have a spread sheet that the only thing I know i that there is a white line separating some data I need to process. I am sure I am way off base and could really use your help. This i what I have: For Each rw In Worksheets("Master").Range("Data").Rows If Worksheets("Master").Range("Data").Cells(rw.Row, 1).BackColor 255 Then ..... Next rw Please Help and Thanks in advance -- bighos ----------------------------------------------------------------------- bighoss's Profile: http://www.excelforum.com/member.php...fo&userid=1471 View this thread: http://www.excelforum.com/showthread.php?threadid=26342 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF statement inside a SUMIF statement.... or alternative method | Excel Worksheet Functions | |||
Reconcile Bank statement & Credit card statement & accounting data | Excel Worksheet Functions | |||
[newbie] if statement | Excel Discussion (Misc queries) | |||
Real Newbie newbie question | New Users to Excel | |||
Newbie Help. Is this possible? | Excel Discussion (Misc queries) |