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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy data not format 9
Copy Array to Array, how to and should I? 13
Excel VBA help: Text file formatting 19
Copy filtered data to sheet 2 1
Want code to copy to ABOVE row 22 column A on sheet 1 10
Get Month and Year ONLY from cell value 2
Scattered array cells copy to scattered array cells another workbook 14
Sheet to sheet code Type Mismatch 6

Back
Top