View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pat Pat is offline
external usenet poster
 
Posts: 122
Default 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