You could build a report: Using QlikView’s Report Editor or look into the capabilities of QlikView NPrinting. To achieve this per macro should be possible, too but isn't definitely easy and needs some efforts. An alternatively might be to hide all unwanted objects (per variable) and print then the sheet.