I have been using the fill-down code below and it works perfect if there is more than 2 rows that it is filling down. However, sometimes I only have 1 or 2 rows and it ends up filling down to the last cell possible in excel. How can I make this formula conditional to correct this?
Code:
Range("L4").Select
ActiveCell.Offset(0, -1).Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 1).Select
Range(Selection, Selection.End(xlUp)).Select
Selection.FillDown