Hello-
I am looking for help on a macro I have written below. It has to do with the autofill destination not working properly with a dynamic range.
Any help to make the autofill code work is greatly appreciated!!
Many thanks,
Nathan
I am looking for help on a macro I have written below. It has to do with the autofill destination not working properly with a dynamic range.
Any help to make the autofill code work is greatly appreciated!!
Code:
Sheets("Macro Workspace").Activate
Dim InvestBoard As Long
InvestBoard = Range("B" & Rows.Count).End(xlUp).Row
Dim Invest As Long
Invest = Range("A4").End(xlDown).Offset(1, 0)
Range("A4").End(xlDown).Offset(1, 0).Formula = "=B" & Invest & ""
ActiveCell.AutoFill Destination:=Range(ActiveCell, Cells(InvestBoard, ActiveCell.Column))
Many thanks,
Nathan