copy all and paste values for all sheets in a workbook

C

cass calculator

how would you copy and paste the values for all sheets in a workbook?

Thanks,

Joshua
 
R

Ron de Bruin

Btw:

If you select all sheets first(group them)
The manual way is working for the selected sheet
 
G

Gord Dibben

Right-click on any sheet tab and "select all sheets".

CTRL + a(twice in 2003) on active sheet to select all cells.

Copy>Paste Special>Values>OK>Esc.

Ungroup the sheets by selecting any sheet but the active one or right-click and
"Ungroup sheets".


Gord Dibben MS Excel MVP
 
C

cass calculator

Sheets
Click to expand...

Thank you. I meant to say programatically, but realized this is the
function group. I shall post on the programming group instead.
Thanks for your help.

Joshua
 
Top