Thread: Fill down range
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nancy[_4_] Nancy[_4_] is offline
external usenet poster
 
Posts: 8
Default Fill down range

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