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. |
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 |