Hi,

Are there anybody out there to explain once and for all the syntax needed. I
often get debugging error claiming "object is missing" or like now with this
simplifyed code below: "Error 1004 Metod Range in object Worksheet failed".

Sub on Sheet 104:

Private Sub Worksheet_Activate()
Sheet112.Range("N29").Copy
Sheet112.Range("C29:G48,C52:G71,C75:G94").PasteSpe cial (xlPasteAll)
End Sub

All my problems started when I decided to stop write code with loops and
selections...

Regards
Gunnar