gsmcconville
06-12-2015, 12:36 AM
Is it possible to copy data from a sheet in a different workbook, to an array?
I know it is possible to do it from within the normal workbook, such as
Dim Buffer() As Variant
Buffer = Range("A1:F10")
But the following does not
Dim Buffer() As Variant
Set WS = Workbooks("Debtors").Worksheets(1)
Buffer = WS.Range("A1:F10")
Is this possible without doing anything like copying one cell at a time, or copying to the current workbook first?
Just curious.
I know it is possible to do it from within the normal workbook, such as
Dim Buffer() As Variant
Buffer = Range("A1:F10")
But the following does not
Dim Buffer() As Variant
Set WS = Workbooks("Debtors").Worksheets(1)
Buffer = WS.Range("A1:F10")
Is this possible without doing anything like copying one cell at a time, or copying to the current workbook first?
Just curious.