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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save all sheets in a new workbook 7
how do i select all cells in a worksheet 3
Macro to copy value in field and insert it into filter 2
How to copy & paste a worksheet but change 1 bit of the formula? 1
Macro to re-protect sheet w/ original password after pasting valuesin new book 1
Easily convert all formulas in 3d spreadsheet to values? 2
how can I disable "cutting cells" and "drag and drop "in excel ? 4
Update multiple sheets 1

Top