I need to unselect the cells in the new worksheet (in new workbook) tha
I'm creating.

I can't seem to figure out how to unselect the cells from the ne
worksheet file that I'm creating. This is the part of my macro tha
creates a separate copy of my current activesheet. The Problem is whe
the Macro creates the new sheet it leaves all the cells selected s
when I open the file again they are all selected. How do I unselect th
sheet prior to the sheet saving?

Dim FileName As String
FileName = "C:\test5\" & Range("C105") & " " & Range("f105")

ActiveSheet.Copy
With ActiveWorkbook
.Sheets(1).Cells.Copy
.Sheets(1).Cells.PasteSpecial (xlPasteValues)
.SaveAs FileName
.Close
End Wit

--
bobwilso
-----------------------------------------------------------------------
bobwilson's Profile: http://www.excelforum.com/member.php...fo&userid=3304
View this thread: http://www.excelforum.com/showthread.php?threadid=52921