+ Reply to Thread
Results 1 to 4 of 4

AutoFill down dynamic range

  1. #1
    Forum Contributor
    Join Date
    01-30-2014
    Location
    England
    MS-Off Ver
    MS Office 2010, 2007, 2003
    Posts
    149

    AutoFill down dynamic range

    I'm trying to autofill down a dynamic range but it's not working for me - gives me multiple errors.

    Biggest problem I'm having is setting the start and end.
    I'm setting FlCol and EdFl as the start and end of the range:
    Please Login or Register  to view this content.
    Honestly - I'm so stumped. Does anyone know how I can autofill down this range please?
    Last edited by Aaron092; 10-15-2014 at 11:35 AM.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: AutoFill down dynamic range

    Can we see more of your code? What exactly does FlCol and EdFL refer too?

  3. #3
    Forum Contributor
    Join Date
    01-30-2014
    Location
    England
    MS-Off Ver
    MS Office 2010, 2007, 2003
    Posts
    149

    Re: AutoFill down dynamic range

    Hi John

    Thank you for your reply - I've managed to work it out now.
    Please Login or Register  to view this content.
    is what I used in the end where EdFl is the end of the list to autofill against, and FlCol is the first cell.

    Thank you again

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: AutoFill down dynamic range

    Glad to here you worked it out.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. AutoFill of Dynamic Range
    By Sevn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-17-2013, 06:03 PM
  2. Autofill using a Macro when range is dynamic
    By CPSmurf in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 09-03-2013, 05:54 PM
  3. VBA Code - Autofill with a Dynamic Range
    By Jurij in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-24-2013, 02:27 AM
  4. Need a macro to autofill a dynamic range
    By missmea2005 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-13-2012, 09:15 AM
  5. Autofill using Dynamic Range (Last Column) and Last Row
    By goldenr2 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-05-2011, 11:21 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