How to clone a worksheet with udf in excel 2007?
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 ?
|