How To Reference Range Inactive Workbook

[jazzjava]

Hi Gang,

New to VBA programming...

I understand how to use .End on Active worksheet: varLocal = Range("A1", Range("A1").End(xlDown)).Value

I understand how to reference a range on an inactive Workbook so that:
varDistant = Workbooks("ElseWhere.xls").Worksheets("Sheet1").Range("C10").Value


I need to combine them ????? So that:

varDistant=Workbooks("ElseWhere.xls").Worksheets("Sheet1").Range("A1", Range("A1").End(xlDown)).Value

But I keep getting errors, Is there something wrong with my syntax ?

[jazzjava]

I got it...

To get an array from the range
It needs to be broken into 2 steps so that...

Set varDistantRange = Workbooks("BookT1.xls").Worksheets("Sheet1").Range("A1", Range("A1").End(xlDown))

varArray = varDistantRange.Value