Select all, but one, sheet?
I need my macro to select all sheets, no matter if they are charts or
worksheets, and no matter how they are named.
I know: Sheets.Select
But, I need my macro to select all, but one: If a sheet has the name
"Periodebalancer", then it should NOT be selected, but still the rest of the
sheets must still be selected.
Sometimes the sheet "Periodebalancer" is present, and sometimes not.
How to accomplish this???
TIA,
|