I figured it out.
I realized that I didn't place a range for the copy
destination. Once i place the range in, then the macro ran
fine.

tks.

-----Original Message-----
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

.