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....
Bookmarks