I have some worksheets where I used some built-in functions and UDF's along with some formatting done to the sheet.



I'm trying to create a macro or something which when I run basically copies the sheet(along with its formatting, styling & cell height width etc.) to a new file and saves it to a workbook in a specific path in D drive without showing a #NAME or #VALUE or any other error and without changing the values.

I'm new to VBA and stuff, can anyone help me with this ?