Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Chigaru Massri   on Sep 10 In MS Office Category.

  
Question Answered By: Marina Smith   on Sep 10

if you want
to select  all the worksheets  and paste  them back to THEMSELVES to
get rid of all the formulas, you can do that with:

Worksheets.Select
Cells.Select
Selection.Copy
Selection.PasteSpecial Paste:=xlPasteValues
ActiveSheet.Select
Application.CutCopyMode = False

but, if you need to copy  all the sheets to ANOTHER workbook, then
you're right, because you can't paste all the sheets at the same
time into a new location. For that, a loop would be needed, as you
said so far as I know.

Share: 

 

This Question has 4 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Selecting all worksheets Or get search suggestion and latest updates.


Tagged: