I have formulas in 4 columns

D,E,F & G

For column 'F' I want to have a macro that willl copy and paste speacial values on click of a button. I tried recording a macro but it copy and paste special on all the columns with a formula and not just column 'F'

Does anybody know the vba code to just copy paste special values on column F:F

Thanks in advance for you help