I have columns A,B,C,D,E all with 66 rows of data(in other samples i have
more or less than the 66 rows, this is just given for my example). In column
F, i have my formula that I want to carry down to row 66.

But when I wite my code "selection.end(xlDown).select" it is selecting the
entire column and when it copies the formula down it goes past my row 66 in
this example and puts 0 in the cells past row 66.

How do you write the code that will select the cells in column F, but will
only select the correct amount of cells dependent on how many rows are filled
in the other columns. All other columns will have the same amount of rows.

Thanks for the help