N
Nancy
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
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