VBA Code to convert multiple Sheets into one PDF

Donna_Dav
Lounger
Posts: 25
Joined: 19 May 2019, 21:03

Re: VBA Code to convert multiple Sheets into one PDF

Post by Donna_Dav »

Hi Hans

Presents a compile error: message at On Error GoTo 0 as ‘Label not defined

Regards Donna
Top
User avatar
HansV
Administrator
Posts: 78417
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA Code to convert multiple Sheets into one PDF

Post by HansV »

Make sure that you have

On Error GoTo 0

with the digit 0 (zero), not with the letter O.
Best wishes,
Hans
Top
Donna_Dav
Lounger
Posts: 25
Joined: 19 May 2019, 21:03

Re: VBA Code to convert multiple Sheets into one PDF

Post by Donna_Dav »

.
Last edited by Donna_Dav on 11 Jun 2019, 18:31, edited 1 time in total.
Top
Donna_Dav
Lounger
Posts: 25
Joined: 19 May 2019, 21:03

Re: VBA Code to convert multiple Sheets into one PDF

Post by Donna_Dav »

Hi
Will double check tomorrow that used zero, cheers
Top
User avatar
HansV
Administrator
Posts: 78417
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA Code to convert multiple Sheets into one PDF

Post by HansV »

. .
Best wishes,
Hans
Top
User avatar
Rudi
gamma jay
Posts: 25455
Joined: 17 Mar 2010, 17:33
Location: Cape Town

Re: VBA Code to convert multiple Sheets into one PDF

Post by Rudi »

Can I going in? It looks fun.


...
Regards,
Rudi

If your absence does not affect them, your presence didn't matter.
Top
Donna_Dav
Lounger
Posts: 25
Joined: 19 May 2019, 21:03

Re: VBA Code to convert multiple Sheets into one PDF

Post by Donna_Dav »

..-.. :-) thanks guys
Top
Donna_Dav
Lounger
Posts: 25
Joined: 19 May 2019, 21:03

Re: VBA Code to convert multiple Sheets into one PDF

Post by Donna_Dav »

Hi Hans
Definitely used zero and bringing back same error message

Cheers Donna
Top
User avatar
HansV
Administrator
Posts: 78417
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: VBA Code to convert multiple Sheets into one PDF

Post by HansV »

I have attached a workbook with the code in a module. It compiles without error. Try copying it from there into your workbook.
ForDonna.xlsm
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Top

Return to “VB/VBA/.Net/Office Scripting”