How to copy a column(number format)from 1 worksheet in another worksheet

[shalskedar]

I need to transfer data from 1 worksheet to another worksheet..

Below is the code i m using to transfer the data..

sub  mm()
Worksheets("planning").Range("P7:P355").Copy
Worksheets("Sheet2").Range("C2:C355").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
        False, Transpose:=False
   MsgBox "done"
end sub

But when i try to do this using vba i get an "#Ref" error..

Can any one help me in fixing this error...

[Jane Alford]

Worksheets("planning").Range("P7:P355").Copy 
Worksheets("Sheet2").Range("C2:C355").PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _

Try using

Sheets("planning").Range("P7:P355").Select
Selection.copy
Sheets("Sheet2").Range("C2:C355").PasteSpecial Paste:=xlPasteAll, etc

That should work.