View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul S Paul S is offline
external usenet poster
 
Posts: 13
Default Looping only through selected sheets

Thanks. Did not think of using the Window object. Though it should be in
the Workbook object.

"Paul S" wrote:

What is the VBA code to loop through only the selected sheets in a workbook?
That is if I have a workbook contain sheets A, B, C, D, and E and if I have
selected multiple sheets, say A, B and E, how do I write code that will
perform operations only on those sheets (A, B, and E)?