Now sure how to get data from another sheet
 

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

Now sure how to get data from another sheet
 

Worksheets("Sheet2").Range("C18")

"cakonopka " wrote in message
...
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 before
"C18" to get it to put the data on another sheet e.g called "sheet2".

Cheers

from CK

I betr this is really simple, lol


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