Help with - Sheets(Array(1, 2, 3)).Select
I can select several sheets with
Sheets(Array(1, 2, 3)).Select
but if i ned to select many sheets, say abot 100 how do i add the
array to do that without writing 1,2,3,4,5,6,7,... manualy ?
by the way is it possible to just add say from 2-45 and 60 to 99 ?
I cant figure this out,
so any help would be greatfull
thanks in advance.
|