Now sure how to get data from another sheet

  • Thread starter Thread starter cakonopka
  • Start date Start date
C

cakonopka

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
 
Back
Top