How would the code know how far down you want to fill ? You want to tell it,
or is there a pattern somewhere ?

Best wishes Harald

"Richard" <Richard @discussions.microsoft.com skrev i melding
...
Selection.AutoFill Destination:=Range("G2:G50")

I don't want it to always autofill to G50 if I can help it, any
suggestions?