In ur code u have
i suppose selection is range("F1")?
does anyone know how to do this for a larger range, for example I need to autofill
GG14:IF14 all the way till the last cell in column A
how should I adapt this code above then?