Selecting sheets - Intelligently
Posted by Dan on July 19, 2000 9:25 AM
I'm sorry if this has been done before, But I need a VBA Macro that will select all sheets in a range except 1. Then move to another sheet.
However my macro collapses as it contains too many lines or names i.e. too many sheets. When I looked at the code it had array and the sheet names or some of them.
Is there a way to do this simply.
I've followed this Message board closely but can't seem to find an answer that I can use - so hence now.
Thanks to any one that can help