Darren You can copy a single worksheet to a new workbook like this. [vba] Worksheets("Sales").Copy [/vba]
Forum Rules