do you want to copy the entire Option 2 section with the cell formatting and formulas as well or only the function column?

the coding is similar but a bit trickier if you say, select something in column E where there are some blanks at the bottom with corresponding funtions in column F

since, it appears that there will always be a function in column F the code could take this in to consideration even when selecting E17