Copy/Paste with Excel

[hobbes2103]

Hi!
I have a form1 and when i press on button1 it opens an Excel sheet, copies the text in cell A1 and pastes it in A2.

Ive tried this copy-paste code :
xlsheet.Range("A1").Copy()
xlsheet.Range("A2").Paste()

Of course it doesnt work and i get an error message : i think i have to select A2 before pasting in it, but i cant figure ou the code for it...

Can someone help me with the copy-paste syntax for Excel in VB.Net?

Thank you!!!

 

[bob01900]

Have you tried this?

oSht.Range("A2").Value = oSht.Range("A1").Value

 

[dynamic_sysop]

objSheet.Range("A1").Copy(objSheet.Range("A2"))
/// that copies A1 and puts it to A2