Changing to a worksheet

Add-in Express™ Support Service
That's what is more important than anything else

Changing to a worksheet
 
gtmoten




Posts: 9
Joined: 2012-09-27
I can retrieve a list of sheets in the active workbook into a string list...
How can i change to a specific sheet?

thank you
Posted 04 Feb, 2013 22:55:41 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Hello Geoff,

Change?

If theRange refers to a range of Excel cells, you can set values to all cells in the range by passing an array of values to theRange.Value.


Andrei Smolin
Add-in Express Team Leader
Posted 05 Feb, 2013 00:35:13 Top
gtmoten




Posts: 9
Joined: 2012-09-27
hi Andrei - sorry.

I mean to activate (change to) a specific worksheet in the workbook - e.g. "Sheet 2"
Posted 05 Feb, 2013 05:26:46 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Ok, understood.

You need to call theWorksheet.Activate. For the correct syntax, please have a look at http://www.add-in-express.com/forum/read.php?FID=1&TID=4477.


Andrei Smolin
Add-in Express Team Leader
Posted 05 Feb, 2013 06:15:59 Top
gtmoten




Posts: 9
Joined: 2012-09-27
perfect - thank you!
Posted 05 Feb, 2013 07:06:15 Top