| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate all sheets
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculate all sheets
Application.Calculate
-- Regards, Tom Ogilvy "Pat" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate individual sheets? | Excel Discussion (Misc queries) | |||
| Calculate data from different sheets | Excel Discussion (Misc queries) | |||
| new sheets by this pc cannot calculate formulas | Excel Discussion (Misc queries) | |||
| Calculate Individual Sheets | Excel Programming | |||
| Calculate Number Of Sheets To Print In VBA | Excel Programming | |||
Linear Mode
