Macro Save with Worksheet as file Name
Hello-
I am trying to create a macro that will save a worksheet as a pdf, and
rename the file to the name of the selected worksheet. Now I have the saving
to pdf part down, but I can't seem to get the renaming of the filename to the
worksheet part down. Does anyone have some ideas how I can do this?
Any help will be greatly apperciated.
Thank you!
BBkixx
|