+ Reply to Thread
Results 1 to 3 of 3

Macro Autofill xlDown

  1. #1
    Registered User
    Join Date
    08-22-2014
    Location
    Seattle,USA
    MS-Off Ver
    2010
    Posts
    2

    Macro Autofill xlDown

    Hi All,
    What I am trying to do seems pretty simple but I have been struggling all morning with my macro.

    I would like to autofill the formula in H2 all the way down in column H to the last active cell contained in column G.
    The number of active cell in column G will vary, so I need to build some flexibility here...

    Could someone please help me?
    See attachmentCapture.PNG

    Thanks,
    Vincent

  2. #2
    Registered User
    Join Date
    08-19-2014
    Location
    Pittsburgh, Pennsylvania
    MS-Off Ver
    2010
    Posts
    45

    Re: Macro Autofill xlDown

    Try:
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-22-2014
    Location
    Seattle,USA
    MS-Off Ver
    2010
    Posts
    2

    Re: Macro Autofill xlDown

    Awesome Jamie!
    Thank you very much!

+ 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. [SOLVED] Very small AutoFill macro showing "AutoFill methode of range class failed" why ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 10:21 PM
  2. Replies: 0
    Last Post: 09-17-2012, 08:24 AM
  3. Macro for Autofill removes header info when there is no data to autofill
    By esturan in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-06-2012, 01:42 PM
  4. xlDown and xlToLeft in a vlookup in a macro
    By Jeremy.S in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-06-2010, 10:12 PM
  5. [SOLVED] Problems with AutoFill xlDown macro on certain computers - DESPERA
    By marika1981 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2005, 09:06 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