Referencing specific cells in an array of ranges

K

ker_01

I have declared
Public AllRanges(1 To 10) As Range
and assigned various ranges to each of the 10 array elements.

Then I use other analyses to identify two "cells" of interest. I'm having
trouble with properly referring to individual cells within the array of
ranges. For example, I would expect something like the following to give me
the value of the first cell in the first range:

Debug.print AllRanges(1)(1,1)
or maybe
Debug.print AllRanges(1)(1,1).value

Since my ranges are all single columns, I also tried to reference this as a
1-D array
Debug.print AllRanges(1)(1) and
Debug.print AllRanges(1)(1).value

but still no luck. Can anyone help me with the syntax of how to properly
reference a single cell's value within an array of ranges?

Many thanks,
Keith
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Offset (trying to resize an element within nested array) 1
Arrays and scattered cell values or another way? 16
Word macro that can call cells out of Excel for a find and replace 0
Strange pasting array to cells behavior 2
CSE with function returning an array? 2
add a specific slide to an array of slides 0
Referring to ranges as Cell, Range, and variables 6
Cell values to an array, then array transpose to another workbook 8

Top