View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Denys[_3_] Denys[_3_] is offline
external usenet poster
 
Posts: 17
Default Replace "A2" with Active cell

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