ok....i actually had an error in my first code but this error should not effect my question

corrected code:
myinputfile.Range("A1:A" & lst_row).FillDown