Save to pdf vba

[orsm6]

Hi all - many macros out there but struggling to find one that simply saves a range on a worksheet to pdf.

preferably just to desktop (or the macro will at least ask user where to save).
also needs to be able to work if the source book is located on a OneDrive if possible.

can anyone point me to a thread or share a code?

TIA

 

[jolivanes]

No, like you wondered, they don't need to be in two different modules but it doesn't matter either.
Very thoughtful of you to show us what works. I am sure there will be people in the future that will be glad they found this thread.