Thread: Now sure how to get data from another sheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nikos Yannacopoulos[_5_] Nikos Yannacopoulos[_5_] is offline
external usenet poster
  
Posts: 80
Default 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/



Reply With QuoteReply With Quote