Results 1 to 7 of 7

Problems with Autofill

Threaded View

  1. #1
    Registered User
    Join Date
    05-29-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    63

    Problems with Autofill

    I’m trying to auto fill to the bottom row of my spreadsheet with the code:

    Sub Step1()
       Dim LR As Long
       LR = Range("O1:P1").End(xlDown).Row
       Range("Q2:AJ2").Select
       Application.CutCopyMode = False
       Selection.AutoFill Destination:=Range("Q2:AJ2" & LR) 
    End Sub
    However it always fills a few hundred rows lower, but I can’t work out why!! Any ideas please?

    Thanks
    Last edited by Cutter; 07-29-2012 at 09:26 PM. Reason: Added code tags

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1