View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
newbie newbie is offline
external usenet poster
 
Posts: 137
Default loop through tabs

Hi
Can anyone help me loop through the tabs in a certain position?
I currently use:
for each ws in thisworkbook.worksheets
but the loops all, I only want to loop the tabs named between eg USaa and USzz

Grateful for all help.