LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SumIf - when I fill down the Range, Criteria & sum range changes markholt Excel Worksheet Functions 3 October 28th 08 12:37 AM
Fill Range With A Value Derek Hart Excel Worksheet Functions 1 December 24th 07 12:55 AM
Fill range/series help required please Loosey Excel Discussion (Misc queries) 5 May 29th 07 07:26 PM
Range Names & Auto Fill Peter Excel Worksheet Functions 2 October 9th 06 09:23 PM
How to fill a range with data from another range? Themis Excel Discussion (Misc queries) 4 September 15th 05 07:29 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"