you could right-click at the bottom, on the name of "Sheet1" and select
"select all sheets"
--
_____________________
Join the club! Havana Club.


"tripflex" wrote:

Okay, after some great help from someone on here to the solution of my
previous question, i now have another one.

I have approximately 100 sheets in a workbook. I want to set the value of
cell C5 to same exact thing for every sheet.

Is it possible to do this without manually going into each sheet and pasting
the code?

Thanks!!