Hi Raul,

Try:

arr = Range(Cells(1, 1), Cells(2000, 30)).Value


---
Regards,
Norman



"Raul" wrote in message
...
Norman,
I did not mean to imply that your syntax was incorrect.

I was asking for the syntax to use if I wanted to refer to the range using
something like the following pseudocode:

xxx = Range(cell(RowNum,ColNum)).Resize(NumOfRows, NumOfCols).Value

I like to use row and column indexes to make this code snippet more
flexible.

Thanks,
Raul




"Norman Jones" wrote:

Hi Raul,

By the way, what is the proper syntax for
xxx = Range("A1").Resize(2000, 30).Value

I could have used the equivalent:

Arr = range("A1:AD2000")

I used the original sytax (which, by the way, is perfectly proper!)
merely to emphasise your information:

I'm usually dealing with arrays that are roughly 2000 X 30
or larger,


---
Regards,
Norman