Thanks for the answers Tom, they are most appreciated. A couple of
questions though - 1) If I don't use .EntireRow won't I get the
intersection of the cell and the entire range("A:F") when all I want is
the items on that one row? 2) By accident, I left off the following
statement in the subroutine: Sub AnalyzeIt(Checkrange as Range) Dim
arr(6) Dim res(2000,6) arr = Checkrange.Value but if I do that,
then I probably don't need the arr(1).value do I, it could just be
arr(1) Is there a way to directly access CheckRange as such as
follows: Sub AnalyzeIt(Checkrange As range) Dim res(2000,6) If Not
CheckRange(1).Value Is Nothing Then etc.