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.

Selecting all worksheets

Question Answered By: Vidos Fischer on Sep 10

Actually the answer was so simple I could not believe it:

Sheets.select will link all the worksheets in the workbook. Then
cell.select highlights all the content in all the cells, and since
all are linked, you have all the sheets doing the same. Then Copy-
paste-values! Then saveAs, done!

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.

Related Topics:

Select a value from a specified worksheet in a closed workbook
How to select specified worksheets by codename
Need help coping images (gif pictures) from worksheet to worksheet
Select worksheet from UserForm
Need help coping images (gif pictures) from worksheet to worksheet
How to select specified worksheets by codename
Excel data transfer automatically from master worksheet to other worksheets
Userform Array to worksheet
Locate the first empty row in a worksheet
Hyperlink to Hidden Worksheet for Excel 2007 Dashboard
Worksheet functions in VBA
Excel Macro help - conditional copy and paste from one worksheet to another
If Cells Have a value, copy and paste into new worksheet
Workbook and Worksheet manipulation
Copy cell contents to same cell on different worksheet if contains
need to merge two worksheets with similar, but not SAME
referencing another worksheet in different workbook?
Create Worksheets from List
saving a worksheet with the name read from a text file
Copy and paste between worksheet with total rows unknown

Tagged:selecting all worksheets

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us