Hello.
First let me give a rundown of the usage of this code / file.
1. Import/Copy a CSV data source to a tab deleting extra entries and columns. (this has been fixed and works great)
2. Copy that data to the Report Tab Pated below the header row that exists in row 25.
3. Filter that pasted data based on the value in Cell b21 which gets its source from a list that is manually updated in the Route Tab Column A.
4) After Filter it applies gridlines to the data for readability and print previews for the user.
5) user repeats process using the next value in the b21 drop down list.
I have tried two different methods one creating a table and one just having a range and both are subject to trailing data / blank pages or error messages when the preview is called. Code examples are below
The method without conversion to a table - gets extra data / pages
The second method converts data to table and comes back with a "Table cannot occupy the same space" Error.
either method is fine functionally as long as there are no extra pages beyond the dataset.
Attached is the code file "Producev3" and the data source "Orders-Result.csv"
Bookmarks