im trying to use this simple code t o copy a particular range from particular sheet to another sheet and specified range.but im encountering the following "application-defined or object-defined error":



For i = 1 To 3

Worksheets("sheet1").Range(Cells(i, 1), Cells(i, 30)).Copy Destination:=(Worksheets("sheet2").Cells(i, 1))
Next

the above code runs from combobox event which is placed in sheet2 i.e, the destination sheet

Im using office 2002

can any body help me out