Results 1 to 6 of 6

Auto fill a range based on another cell

Threaded View

  1. #1
    Registered User
    Join Date
    07-28-2009
    Location
    Chicago, Il
    MS-Off Ver
    Excel 2007
    Posts
    67

    Auto fill a range based on another cell

    Hello all,
    I am having a problem and need some assistance. I am auto filling a range of cells on O2 down with a formula and have it stoping all the way down at O12982, the problem i have is that my data can stop before or after that point depending on the report. so how can i say that it should auto fill as long as there is data in A column

     
    Range("O2").Select
        ActiveCell.FormulaR1C1 = "=RC[-1]/60"
        Range("O2").Select
        Selection.AutoFill Destination:=Range("O2:O12982")
        Range("O2:O12982").Select
    Thanks
    Last edited by Ricardo9211; 07-29-2009 at 04:29 PM. Reason: did not code listed correctly

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