Please explain syntax needed

N

Nobody

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").PasteSpecial (xlPasteAll)
End Sub

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

Regards
Gunnar
 
D

Don Guillett

I just recorded this
Sub Macro6()
Macro recorded 6/3/2004 by Don Guillett
Selection.Copy
Range("A6,F6,G3,G6").Select
Range("G6").Activate
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False
End Sub
so boiled down, it could be
Sub Macro6()
range("a1").Copy
Range("A6,F6,G3,G6").PasteSpecial Paste:=xlPasteAll
End Sub
 
Top