I use the following code in Excel VBA to copy a Excel sheet for calculation:
Dim Store1Sheet() As Varient
Store1Sheet = Range("A1:D99")
Please would you adivse how to copy several Excel sheets to 1 variant, says StoreMultiSheet.
Many thanks.
____________________________________
I find the solution as follow:
Dim StoreMultiSheet(1 to 10) As Varient
Dim SheetNo As Integer
For SheetNo = 1 to 10
StoreMultiSheet(SheetNo) = Worksheets(SheetNo).UsedRange
Next SheetNo