Denys submitted this idea :
Good day everyone,
Would someone be kind enough to let me know how I could replace "A2"
by the active cell in the following formula:
With ActiveSheet
.Cells(1, 1).End(xlDown).Offset(1).Select
.Range("A2", .Cells(UBound(Arr, 1), UBound(Arr,
2))).Value = Arr
End With
Thank you for your time
Denys
To 'dump' an array into a range you need to pick the top left cell and
resize that to the rows/cols of the array. So...
ActiveCell.Resize(Ubound(Arr, 1), UBound(Arr, 2) = Arr
Also, it's not necessary to select anything and so...
Sub DoStuff()
' Reads a 5Row x 5Col range into an array,
' then dumps the data back into the sheet
' at the 1st empty row below existing data.
Dim Arr
Arr = Range("A1:E5")
Cells(1, 1).End(xlDown).Offset(1).Resize(UBound(Arr, 1), UBound(Arr,
2)) = Arr
End Sub
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc