Loading

SELECT ALL SHEETS IN BOOK

richard smith

I know to select a specific sheet, or how to select the sheets when you know how many the workbook will have. But how in C# can you select ALL the worksheets in the Activeworkbook?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
I think that you'll need to iterate through the Worksheets collection and select each one in turn.

Try the following:

foreach (Excel.Worksheet ws in oXL.ActiveWorkbook.Worksheets)
{
ws.Select(false);
}