macro to 'save as pdf' that prompts for filename, location AND only prints specified range

I put this together pretty fast --- I used a formula on the far left to decide to show or hide the row - Then wrote the macro only show the desired rows and to save as a PDF to the Desktop... Not sure if this is the solution you were looking for, but pretty user friendly with a ton of different applications. Check it out and let me know what you think.

If you want to use to make it 'Print ready'... You could write a macro and add it to this before the "Call PDF"...

Sub FINALMACRO()
Application.ScreenUpdating = False

Call UNHIDE
Call SEARCH
Call PDF

End Sub


Hope it helpss

I do like this option for hiding/unhiding, but I prefer that the user doesn't have to reset/implement the hiding. The goal is for the user to just press the designated button and have it save to PDF. Also, this doesn't prompt the user for a filename or file location.

For some reason (could it be due to the order of events,) the saved PDF that my macro creates prints the entire sheet instead of the range. I think that is my biggest beef with the macro I have...my wish list would then be to concentrate on having the user be able to name and save it to where ever they desire.

Thanks for giving it a go tho...your method of filtering is pretty cool.

Gotcha - I've got a bunch of stuff to work at the moments, but I'll try to get back to you later this afternoon.

Ok --- This should do it...

Just added a Save as message box (which updates cell A1) --- I call all the macros, and then rerun the "Unhide" so that the file doesnt need resetting...

Let me know if it helps,

Please Login or Register  to view this content.

Thanks for your help! Looking at this allowed me to integrate it into the code I had already written. Thanks again for your time. It is greatly appreciated!

M