Results 1 to 10 of 10

Autofill Destination Range

Threaded View

ERaasio Autofill Destination Range 03-14-2014, 12:28 PM
Norie Re: Autofill Destination Range 03-14-2014, 12:32 PM
ERaasio Re: Autofill Destination Range 03-14-2014, 02:00 PM
Norie Re: Autofill Destination Range 03-14-2014, 02:08 PM
ERaasio Re: Autofill Destination Range 03-14-2014, 02:14 PM
Norie Re: Autofill Destination Range 03-14-2014, 02:36 PM
ERaasio Re: Autofill Destination Range 03-14-2014, 02:42 PM
Norie Re: Autofill Destination Range 03-14-2014, 02:50 PM
ERaasio Re: Autofill Destination Range 03-14-2014, 02:57 PM
Norie Re: Autofill Destination Range 03-14-2014, 03:02 PM
  1. #5
    Registered User
    Join Date
    06-27-2013
    Location
    Va Beach
    MS-Off Ver
    Excel 2003
    Posts
    38

    Re: Autofill Destination Range

    The report size changes daily. So monday it maybe 50 entries long where on Tuesday it could 1100 entries. But row 15 is where I enter the data. So after I format O15:O16 I need to copy those two lines and start from O17 and go to the last O row(basically the Last row of P since O is blank). So if the last row of P is 90 it would autofill from O17:O90.
    Last edited by ERaasio; 03-14-2014 at 02:15 PM. Reason: changed if to of

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Autofill a destination range using last row value
    By jaym911 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-29-2013, 12:07 PM
  2. [SOLVED] AutoFill Destination Unknown Range
    By sperry2565 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 07-08-2013, 04:53 PM
  3. How to extend Range.AutoFill Destination down an addition 3 rows?
    By BBoydAnchor in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-31-2011, 10:51 AM
  4. Autofill in VBA with a dynamic "Destination" range
    By ConneXionLost in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-04-2011, 04:55 PM
  5. Selection.Autofill Destination:=Range(ActiveCell.Value)
    By Shaka215@gmail.com in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-23-2006, 06:20 PM

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