ActiveSheet change form VB.NET

[mqdias]

Hi,

I'm developing an little application with VB.Net, that involve Excel.

I am copying Textbox contents to Excel cells. I have the following code to copy them to "Sheet1".

Please Login or Register  to view this content.

Now, i want to change the Activesheet to "Sheet2" to copy some values, and return to activate "Sheet1" again.

How can i do this?

thanks

[royUK]

You do not need to select a sheet to copy from it. Maybe you need

Please Login or Register  to view this content.

[mqdias]

I've already tried to use this code:

Please Login or Register  to view this content.

to select the sheet that i want to copy to, but it didn't work.

What is happening?

[royUK]

I'm not sure, I have little experience of VB.Net