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.

 

I've tried this copy-paste code :

xlsheet.Range("A1").Copy()

xlsheet.Range("A2").Paste()

 

Of course it doesn't work and i get an error message : i think i have to select A2 before pasting in it, but i can't figure ou the code for it... :confused:

 

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 

:)