Hello, I have a data entry userform that is supposed to enter data into the sheet, and then copy down formulas from the respective columns. The problem I seem to have is that it is copying down the formula's to roughly 200 further than the "bottom" - is there anything particularly obviously wrong with my code?
Note - I've taken out other code that was inputting the data into the sheet as it isn't relevant
Note - I've taken out other code that was inputting the data into the sheet as it isn't relevant
VBA Code:
Private Sub writedatatosheet()
Dim lastrow As Integer
lastrow = Cells(Rows.Count, "A").End(xlUp).row
With ActiveSheet
.Range("AD2:AZ2").AutoFill Destination:=.Range("AD2:AZ2" & lastrow)
End With
End Sub