from
'POSSIBILITY #3 - ONLY DEF CELL = 1 ("GOOD" DATA)
Case (Left(rTEST.Cells(iBB_DATA_Row, 1), 4) = "#N/A" And _
Left(rTEST.Cells(iBB_DATA_Row, 2), 4) < "#N/A" And _
Left(rTEST.Cells(iBB_DATA_Row, 3), 4) = "#N/A")


To
Select Case ISNA(Left(rTEST.Cells(iBB_DATA_Row, 1), 4)) And _
ISNA(Left(rTEST.Cells(iBB_DATA_Row, 2), 4)) And _
ISNA(Left(rTEST.Cells(iBB_DATA_Row, 3), 4))

Case TRUE
Case FALSE
end select



True usally means 1, and False is any other value beside 1. False is
define as NOT TRUE.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=199358

http://www.thecodecage.com/forumz