try right click sheet tabselect all sheetsdo your thingselect any sheet

--
Don Guillett
SalesAid Software

"Wanna Learn" wrote in message
...
Hello I have a workbook with 32 worksheets. Before I send out the report
I
copy- paste special -values each sheet. Is there a faster way to do this.
thanks