View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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