Saving specific columns in a sheet as a PDF file

[Zahid0111]

The following code save entire sheet as PDF file and is working fine. But i want specific columns to be saved as a PDF which are given below:

Columns to save only: A, B, D, E, O, P, W, X, AD, AE, AJ, AK, AP, AQ, AS, AT.

How to do this, please help

Please Login or Register  to view this content.

I have posted this here too:https://www.facebook.com/engr.zahidh...location=group

[CK76]

Something like below should do it.

Please Login or Register  to view this content.

NOTE: You should probably set print area before you export.

[Zahid0111]

@CK76 I have some merged Cells in the sheet due to which the following error arose.

[CK76]

Without sample workbook can't help you much.

In general, avoid merged cells at all cost. It's just visual fluff and causes more issue than what it's worth.

[Zahid0111]

Here is the sample file please
and i want only these columns to be saved in pdf
A, B, D, E, O, P, W, X, AD, AE, AJ, AK, AP, AQ, AS, AT.

[CK76]

Do you want to copy entire column? Or just the data range starting from Row 12?

If you need range above row 12... you'll need separate process to copy that range separately.

[Zahid0111]

Yes entire columns till end of data

[CK76]

Then please replicate what end result before export should look like (in another sheet) and upload.

I'll try to match what your end result looks like via code.

[Zahid0111]

Please check the attached file...i need only these columns

[CK76]

Here, try this then.

Please Login or Register  to view this content.

[Zahid0111]

This works great...Thank you so much CK76...