Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel VBA Array to be expressed as a variation of Partial Dimension
Re : Excel VBA Array to be expressed as a variation of Partial
Dimension 1. Enters an Excel worksheet. 2. Assume that, Dim Xrange as Variant 3. To read into Xrange, Xrange = ActiveSheet.Range(A1:A10) 4. And then, Xrange contains 10 elements. 5. Programming logic follows that it would be required to examine the contents of Xrange but merely the second half of the stated array namely, Xrange(6) to Xrange(10). 6. To exemplify the query conceptually, would it be veritable to express as follows, (Xrange(I,J), I = 6 to 10, J=1) or, Alternatively ? 7. Please share your experience. Regards. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel VBA Array to be expressed as a variation of Partial Dim
for i = 6 to 10
msgbox "xRange(" & i & ",1)= " & xRange(i,1) Next -- Regards, Tom Ogilvy " wrote: Re : Excel VBA Array to be expressed as a variation of Partial Dimension 1. Enters an Excel worksheet. 2. Assume that, Dim Xrange as Variant 3. To read into Xrange, Xrange = ActiveSheet.Range(A1:A10) 4. And then, Xrange contains 10 elements. 5. Programming logic follows that it would be required to examine the contents of Xrange but merely the second half of the stated array namely, Xrange(6) to Xrange(10). 6. To exemplify the query conceptually, would it be veritable to express as follows, (Xrange(I,J), I = 6 to 10, J=1) or, Alternatively ? 7. Please share your experience. Regards. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel VBA Array to be expressed as a variation of PartialDimension
wrote:
Re : Excel VBA Array to be expressed as a variation of Partial Dimension 1. Enters an Excel worksheet. 2. Assume that, Dim Xrange as Variant 3. To read into Xrange, Xrange = ActiveSheet.Range(A1:A10) 4. And then, Xrange contains 10 elements. 5. Programming logic follows that it would be required to examine the contents of Xrange but merely the second half of the stated array namely, Xrange(6) to Xrange(10). 6. To exemplify the query conceptually, would it be veritable to express as follows, (Xrange(I,J), I = 6 to 10, J=1) or, Alternatively ? 7. Please share your experience. Regards. If the functions in the freely downloadable file at http://home.pacbell.net/beban are available to your workbook PartialXRange = SubArray(XRange, , , 6, 10) Alan Beban |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Re : Excel VBA Array to be expressed as a variation of Partial Dimension
Mr. Tom Ogilvy and Mr. Alan Beban,
Thank you very much indeed. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
INDIRECT - only partial variation to formula | Excel Worksheet Functions | |||
Put values into excel range from single dimension array | Excel Programming | |||
Mutli-dimensional Array to Single-Dimension Array | Excel Programming | |||
Array transfer - 1 dimension v. 2 dimension | Excel Programming | |||
Getting excel array dimension | Excel Programming |