Storing multiple ranges using a macro

  • Thread starter Thread starter Chaman
  • Start date Start date
C

Chaman

I have to play with lot of ranges in a worksheet. Say range1 is from
A1:A10, range2 is from B1:B10 and so on. I have 1000s of such
ranges.

One of doing it is defining individial ranges say

dim range1 as range
dim range2 as range
.....
....
....

etc.

I dont want to use 1000 variables for 1000 different ranges. Is there
any way of creating an array of ranges? OR Whats the best way of
doing it?
 
Hi

Sure, you can use an array:

Sub Test()
Dim RangeArray(1000) As Range

For c = 0 To 999
Set RangeArray(c) = Range("A1:A10").Offset(0, c)
Next
End Sub

Regards,
Per
 

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

Storing multiple ranges using a macro 3
Macro Ranges 1
Reconciling Data Ranges 2
Generic Worksheet Names 2
SUMPRODUCT: Can you use this and sum the values from multiple colu 8
Sum of the intersect of two named ranges 5
INDEX return multiple columns 1
Using ranges with Visual Basic, stuck... 6

Back
Top