Select Last Cell And Fill Down

  • I want to select the cell under the last cell of a particular worksheet and use the filldown function


    This is the code i am tryin to use but won't work


    Code
    Worksheets("CD").Range("A1").End(xlDown).Row + 1.Select
    Selection.FillDown


    If anyone has any ideas it would be much appreaciated.

  • Re: Select Last Cell And Fill Down


    Code
    Worksheets("CD").Cells(Rows.Count,1).End(xlUp).Offset(1).FillDown


    ?
    or

    Code
    Worksheets("CD").Cells(Rows.Count,1).End(xlUp).Resize(2).FillDown


    ?

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!