+ Reply to Thread
Results 1 to 1 of 1

Inserting rows whilst keeping filter range.

  1. #1
    Forum Contributor
    Join Date
    11-26-2008
    Location
    UK
    MS-Off Ver
    Using Excel 2019
    Posts
    317

    Inserting rows whilst keeping filter range.

    I have found and used the code below which inserts a user defined number of rows into the open worksheet (or multiple worksheets if you select them together). The row i use to click in before adding the extras is always Row 13.

    This works really well, with one problem. When I add the extra rows the filter I have set up (range: $A$8:$L$13) does not 'grow' to include the added columns. Instead it only includes information included in the single existing row (Row 13). The ones that appear below it are left out of the filter.

    Anyone know how i can solve this? I've tried fiddling with the VBA code but with no luck....The code im using for the macro to add extra rows is as follows....

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by Barking_Mad; 06-16-2010 at 10:09 AM. Reason: added example file

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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