Message to show name of file saved as a folder

I have the following code below to save a sheet

I would like a message box to pop up advising the folder sheet saved to as well as name of file saved or alternatively to extract this when saving and place it in cell G14 on sheet "Macro"


It would be appreciated if someone would kindly amend my code accordingly

Please Login or Register  to view this content.

Just add this

Please Login or Register  to view this content.

Thanks for the help Fluff

Please advise how to extract this to cell G14 on sheet "Macro"

Just replace the MsgBox with the sheet name & range

Thanks for your input Fluff

Thanks for the help Nigelog

There was one slight typo str should have been fstr

You're welcome & thanks for the feedback

@Howard - I was wondering when you would spot that lol

Thanks for feedback