selected a range by hand and all sheets after have the same range selected

[Ratigan1970]

hi everyone
its a bit of a strange question
im trying to find some vba to help me speed up my work
what i have is multiple sheets (approx 90). from my master sheet i would like to highlight
a range by hand and all the sheets after the master sheet be highlighted the same.
is it possible???

 

[FormR]

Hi, right cick any sheet and choose "select all sheets" make your selection then right click any sheet again and choose "Ungroup sheets"

 

[Ratigan1970]

Hi, right cick any sheet and choose "select all sheets" make your selection then right click any sheet again and choose "Ungroup sheets"

hi and thank you for your quick reply this works but it also selects the sheets before the master sheet (sorry i forgot to add that to the post)

 

[FormR]

You can activate the first sheet, hold the SHIFT key and click on the last sheet to group all the sheets in between or you can hold the CTRL key down whilst clicking on sheets to add them or remove them from the group or you can use a combination of both - remember to "ungroup" afterwards