I'm new to VBA and stuck at a point where I need to save 2 sheets in a single PDF.
I tried this, but it fails.
Please help me correct this!Please Login or Register to view this content.
I'm new to VBA and stuck at a point where I need to save 2 sheets in a single PDF.
I tried this, but it fails.
Please help me correct this!Please Login or Register to view this content.
Wasn't this answered in your previous post?
http://www.excelforum.com/showthread...=1#post4441375
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Try this.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
It works partially here! It is also taking Sheet3 into consideration to save as PDF.
Another problem is that it is not hiding the columns C:G when it is generating the PDF.
How do I avoid that?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks