Deselecting after copy-paste

Posted by Shanna on January 01, 2002 8:31 AM

The following macro leaves the copy-paste area selected. Anyway to unselect this before moving on to the next worksheet. Thanks :-)

Dim Sht As Worksheet
For Each Sht In Worksheets
With Sht.UsedRange
.Copy
.PasteSpecial xlValues
End With
Next
End Sub

Posted by Barrie Davidson on January 01, 2002 8:43 AM

Try inserting this just before your "Next" statement:

Activecell.Select

Regards,
BarrieBarrie Davidson

Posted by Jim on January 01, 2002 8:45 AM

Shanna,

If i understand you correctly, Try this

Application.CutCopyMode = False
Or Select a Range, Range("A1").Select

Jim