Nancy wrote:
I'm getting a debug error at the Selection.Autofill part.

What is the error message?
What is in F2?
Do the cells from F3 to the "end of the column" already have something
in?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - reply in newsgroup