Code to extract tables to PDF

[AliciaGoyanes]

Hi everyone,

I am new to this forum. I am trying to do the following: extract certain tables from excel into a pdf.

Is there any code to do so and extract certain rows and columns (e.g. A2:C10) from (e.g. Sheet 1) and through a button extract those cells selected to a pdf?

I'd like to be able to adapt the rows and columns and sheet names in the code, so for the exercise:

A2:C10 from Sheet 1 called 'Sheet 1'

C40:D40 from Sheet 2 called 'Sheet 2'

As I will add some comments above each table in the same pdf, I would like to have a space of around 5-7 lines between each table. I am not sure if that's possible.

Tks a lot in advance.

 

[John_w]

Welcome to MrExcel forums.

To save multiple ranges on different sheets to a single PDF you have to copy the ranges to a temporary sheet, putting them in suitable cells to give the required spacing, add the comments in cells and save it as a PDF.

See if this code helps to get you started:

Multiple Range to one PDF from 4 sheets

Hi, I have multiple sheets in my file and I need to export as PDF from the selected range of selected sheets, I have used the below code but it is not working properly, PDF generated but range not pick from as mentioned in the below code. it takes from first sheet all data. Please suggest if I...

www.mrexcel.com