Macros-autofill down to one row above next data field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried using the relative reference to automatically (shift-end-down arrow
then up arrow one row) to autofill. The number of rows will vary each time.
The macro doesn't record properly.

What is the best way to handle this?

Thank you.
 
Sub Selectdown()
Range(ActiveCell, ActiveCell.End(xlDown).Offset(-1, 0)).FillDown
End Sub


Gord Dibben MS Excel MVP
 
That does it. Thank you.
Terry

Gord Dibben said:
Sub Selectdown()
Range(ActiveCell, ActiveCell.End(xlDown).Offset(-1, 0)).FillDown
End Sub


Gord Dibben MS Excel MVP
Click to expand...
 
Back
Top