Hi drewbizz,
I wish it were so easy. BUT be careful what you wish for.
I just recorded a macro that selected 3 sheets and the line of code looks like:
The above is what you are going to want in the remarked out line I wrote above.
I really don't want to write this code for you as it is too dangerous. The reason is - If you select multiple sheets and type something into one of them it will do the same thing to all the selected sheets. This will destroy or overwrite stuff that you may not want to change on the sheets you can't see.
Time to learn some VBA?
Bookmarks