Copy worksheet as values only

[saravnepali]

I have a worksheet which I want to copy on a new workbook.

But, I don't want to have the formulas retained but values only from the old sheet - formatting if possible.

[oeldere]

@saravnepali

It is good practice on forums to reply on the given solutions.

Below your earlier question on the forum.

https://www.excelforum.com/access-pr...th-spaces.html

[saravnepali]

@saravnepali

It is good practice on forums to reply on the given solutions.

Below your earlier question on the forum.

https://www.excelforum.com/access-pr...th-spaces.html

I usually do come back.

Thanks Oeldere for the reminder.

[mazan2010]

Please check attached file with macro to create new workbook with value from sheet in selected range

[saravnepali]

Thanks

This helps