Automation - Sheet switch in Excel

Imre
Imre Member Posts: 10
Hello ,

I can not find the excel object/property switching to another sheet.
Example the Sheet1 is active but I need to switch to Sheet2.

Thanks in advance for the answers.

Imre

Comments

  • nelson
    nelson Member Posts: 107
    Something like this should do the trick:
    Worksheet := Sheets.Item('My Sheet');
    Worksheet.Activate;
    
    Nelson Alberto