+ Reply to Thread
Results 1 to 4 of 4

AutoFill on a Filtered Range

  1. #1
    Registered User
    Join Date
    07-24-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    97

    AutoFill on a Filtered Range

    Hi

    I have working code that AutoFills the content of I4 down all rows in Column I starting from I6 and based on last row of column G. What I need however, is for it to do the same but only on the rows in a FILTERED list.

    To start this I first manually select the first cell in the filtered range in order to get the ActiveCell (if there is code which will find the first row of a filtered list for me I would like to include it), then I run the code. This is where I get stuck. I have tried heaps of ways but cannot get it to work on a filtered list.

    Help please.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: AutoFill on a Filtered Range

    Try
    Please Login or Register  to view this content.
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Registered User
    Join Date
    04-07-2019
    Location
    Turkey-Ankara-Çubuk
    MS-Off Ver
    Office 2010
    Posts
    50

    Re: AutoFill on a Filtered Range

    try...
    Please Login or Register  to view this content.

  4. #4
    Registered User
    Join Date
    07-24-2013
    Location
    New Zealand
    MS-Off Ver
    Excel 2010
    Posts
    97

    Re: AutoFill on a Filtered Range

    Thank you.

+ 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. Facing an issue to correctly autofill according to filtered data with macros
    By immillen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-13-2020, 08:32 PM
  2. VBA to paste range skipping filtered rows & what is the range copy buffer called
    By foxtrotter in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2020, 09:34 PM
  3. Copy filtered data into filtered range in a separate sheet
    By vikas.trades25 in forum Excel General
    Replies: 1
    Last Post: 02-07-2019, 04:04 AM
  4. Replies: 3
    Last Post: 05-07-2017, 02:53 PM
  5. [SOLVED] Excel VBA - Issue in Naming Filtered Range on a Filtered List.
    By Vinod Krishna.C in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-06-2014, 01:17 PM
  6. [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
  7. Replies: 6
    Last Post: 02-20-2010, 12:44 AM

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