Hi, I can't work out what to put after (strSourceSheetName) to get it to
work, the worksheet it needs yto show is (Sheet1) - i.e. the standard
worksheet names.

'set object refs to both source and target
Set ShtSource = CurrentWrkBook.Worksheets(strSourceSheetName)
Set ShtTarget = NewWrkBook.Worksheets(strTargetSheetName)

Any help would be much appreciated.

Thanks

Windows XP Professional
Office 2003