Forum Discussion
Problem when using PasteSpecial with SkipBlanks on filtered table
I have written a VBA script to produce a report from an Excel table. Basically, the VBA script filters the table based on user selected criteria. It then copies a range of cells (using SpecialCells(x...
It sounds to me as if you're involving VBA when you don't need to. If you have the most recent version of Excel installed, there's now a function called FILTER that can itself filter a table according to user-entered criteria. The report could then be generated from that filtered table.
Here's a great video that explains the function. https://www.youtube.com/watch?v=9I9DtFOVPIg
Thanks mathetes,
Unfortunately the filter function is not adequate in this instance as my code is part of a much larger piece which automates the production of multiple reports (separate workbooks).
Unfortunately the filter function is not adequate in this instance as my code is part of a much larger piece which automates the production of multiple reports (separate workbooks).