Diving_Dan
Board Regular
- Joined
- Oct 20, 2019
- Messages
- 161
Hi all,
I'm having a nightmare trying to autofill. I have tried recording a macro to find the solution but it isn't giving me the right answer.
I am wanting to go to the last row with data and then autofill down 1 row. I have come up with the below but it doesn't work properly.
Any help is appreciated as always.
I'm having a nightmare trying to autofill. I have tried recording a macro to find the solution but it isn't giving me the right answer.
I am wanting to go to the last row with data and then autofill down 1 row. I have come up with the below but it doesn't work properly.
Any help is appreciated as always.
VBA Code:
Cells(Rows.Count, 1).End(xlUp).Select
Selection.AutoFill Destination:=Range("A5:A6"), Type:=xlFillDefault