MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Selecting all sheets


Posted by Max on August 30, 2000 2:48 AM

Is there a code to select all sheets in a workbook without the need for sheets(array + the sheetnames).select

Surely there must be a simpler way?

Can any one help.

Cheers.

Max


Posted by Celia on August 30, 0100 3:15 AM


Max
You can select all sheets with :-

Worksheets.Select

However, to make changes to all sheets at the same time, I think the cell being changed needs to be activated. Something like this :-

Worksheets.Select
Range("A1").Activate
ActiveCell.Value = "Max"

Celia


Posted by Max on August 30, 0100 4:19 AM

Thanks

Thanks.

Max