Newbie needs help with if statement
 

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

Newbie needs help with if statement
 

The function is Interior.ColorIndex, I believe. You'll have to figure out what
the index is for White. Or use the Interior.Color with the RGB value.

On Fri, 24 Sep 2004 23:34:37 -0500, bighoss
wrote:


I need an if statement that looks at a specific field and checks to see
if it is white. I have a spread sheet that the only thing I know is
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 is
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.