I have the following work around to replace the manual "fill down" (using fill handle). Is there a better way of doing this?
Thank you,Range("B2").Select Selection.Copy ActiveCell.Offset(0, -1).Select Selection.End(xlDown).Select ActiveCell.Offset(0, 1).Select Range(Selection, Range("B2")).Select ActiveSheet.Paste
Jay
Bookmarks