Autofill until

Hi all! Does anybody know a simple macro code for autofilling cells in a column until a certain cell is reached. Ie. I'd like to autofill from cell F2 all the way to cell F50 only. Any help on this would be great. Thanks!

Did you know: you can build such a macro yourself by recording it.