I've been searching all my favorite boards and am either using the wrong keywords or whatever.
I'm trying to copy one sheet to a new workbook.
I know this is easy to do but I'm hitting errors like crazy. I've tried using this code.
Thanks for any help.
I'm trying to copy one sheet to a new workbook.
I know this is easy to do but I'm hitting errors like crazy. I've tried using this code.
Code:
wb = Workbooks.Add
Sheets("Tracking sheet").Copy.UsedRange
wb.Range("A1").Paste
Thanks for any help.