Calculate all sheets

  • Thread starter Thread starter Pat
  • Start date Start date
P

Pat

When I sort a sheet other sheets in the workbook with links to the sorted
sheet need re-calculated. I use as part of the custom sort code:

Worksheets("Sheet1").Calculate

Is there an easier way to sort all sheets in the workbook, bearing in mind
they have different names (not sheet1, sheet2 etc)

Pat
 
You must log in or register to reply here.

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

Excel VBA help: Text file formatting 19
Worksheet sorting code/technique advise 55
Unhide sheet, copy and rename new sheets from list, rehide sheet 8
Merging 2 sheets. 1
[Q] How to sort tabs in order of CodeName 2
Calling routines from different sheets 1
Sort Worksheets Numerically 2
Sheet to sheet code Type Mismatch 6

Back
Top