Thanks, Ron and Bob.

Comp Date is the column name for column H in the spreadsheet.

I was able to specify the column with Ron's suggestion:

Code
-------------------
If Cells(Bcell.Row, "H").Value < "
-------------------


However, my code is not actually doing what I intended (my fault). I'l
need to rethink my logic. I need to step through each row and then chec
column H for values before moving the row to another sheet. The way m
code is written, it is stepping through every cell.

The For statement should be something like this:


Code
-------------------
For Each *Row* In Worksheets("Master").Range("A2", LastCell
-------------------


LastCell holds the address of the last cell in the last row tha
contains values. I'll have to figure out how to step through each row
select it or make it active, and then do the If statement and th
remaining code

--
David
-----------------------------------------------------------------------
DavidW's Profile: http://www.excelforum.com/member.php...fo&userid=3263
View this thread: http://www.excelforum.com/showthread.php?threadid=57427