Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic Question on Subs | Excel Worksheet Functions | |||
Common Functions and Subs | Excel Discussion (Misc queries) | |||
General Question regarding passing cells, ranges, cell values through subs & functions | Excel Programming | |||
Passing values between 2 subs ? | Excel Programming |