Thanks,
I figured it was something simple but I'm pretty green to this aspect of Excel
Paul

"Michael" wrote:

> 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
> >