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

I'm copying a cell from one sheet to a cell in another.
Then trying to fill down the formula until the end of data
for the column.

Can you tell me what is wrong with my code.

Tks.


Sheets("BLP_SETUP").Select
Application.Run "BLPLinkReset"
Selection.Copy
Sheets("pending_settlements").Select
Application.Run "BLPLinkReset"
ActiveSheet.Paste
Application.CutCopyMode = False
Range("F2").Select
Selection.AutoFill Destination:=Range(ActiveCell, _
ActiveCell.End(xlDown))
Application.Run "BLPCreate"
Application.Run "RefireBLP"
Range("F2").Select

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

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

.