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
>