Should I copy ranges or just leave them alone so this works? I need to copy 1.3 ml range and paste it to a new worksheet. Sep 11, 2023 — How can I duplicate columns in a table to a new workbook? Feb 3, 2023 — Hi, I need to export multiple ranges to a single PDF using VBA. It seems you have to do it manually, but I would like to check if I can automate my workflow to export multiple ranges with different data.