ExcelBanter - Specify which sheet to paste to

Change ActiveSheet.Previous.Select to
Sheets("Link").select

"Paul LeBlanc" wrote:

I have recorded a simple macro and want to specify that it always pastes into
the sheet named 'Link'
here is my current code
Sub McrUpdateLink()
'
' McrUpdateLink Macro
' Macro recorded 06/15/2006
'

'
Cells.Select
Selection.Copy
ActiveSheet.Previous.Select
Cells.Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Application.CutCopyMode = False
Range("A2").Select
ActiveSheet.Next.Select
Range("H2").Select
End Sub