General Question regarding passing cells, ranges, cell values through subs & functions
 

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.

General Question regarding passing cells, ranges, cell values through subs & functions
 

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?

If you want the whole row, then you would need Entirerow. It wasn't clear
that is what you wanted.


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.


yes, you can use CheckRange(1) to refer to column a of the A to F range and
CheckRange(2) to refer to Column B. etc

but why would CheckRange(1) be nothing? Not sure you need this check. Your
code doesn't call AnalyzeIt unless there is an intersection and so
EntryIsValid should produce a range.



--
Regards,
Tom Ogilvy




" wrote in message
...
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.