OWC.Spreadsheet: Activate Sheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The default workbook created by this component has 2 sheets. I can refer to the ActiveSheet without problems.
How do I refer to the other two sheets?
How do I activate another sheet, say sheet3, using C# code?
Thanks.
 
The same way you would in Excel, using the Sheets collection an the Item
method to index each sheet.

--
John Wood
EMail: first name, dot, last name, at priorganize.com
AA2e72E said:
The default workbook created by this component has 2 sheets. I can refer
Click to expand...
to the ActiveSheet without problems.
 
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

Excel shortcut options 0
Excel Macro to un-mute Audio/speakers. 15
Code to format cells on several worksheets 2
Refer to a lone sheet 5
Excel Cannot delete empty cells/rows 4
Excel vba code to match duplicates 4
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Run macro from active workbook whose name keeps changing 20

Back
Top