hi
Iam using officeXP and the following VBA code is not working in EXCEL. I would greatly appreciate if somebod
can tell me the correct way to do this code. I get 'select method of range class failed" error message

' here is the cod
dim cvalue as intege
cvalue=
Worksheets("sheet2").Selec
Range(Cells(cvalue, 1), Cells(cvalue, 54)).Selec
Selection.Cop
Sheets("Sheet3").Selec
Rows("2:2").Selec
ActiveSheet.Past

' end of cod

thank
Kana
Any ideas?