Hi there all

Private Sub CommandButton1_Click()
Range("A1").Copy Destination:=Range("C18")
Range("A1").ClearContents

End Sub

I have this command, i just want to know what i would write befor
"C18" to get it to put the data on another sheet e.g called "sheet2".

Cheers

from CK

I betr this is really simple, lo

--
Message posted from http://www.ExcelForum.com