View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
jlclyde jlclyde is offline
external usenet poster
 
Posts: 410
Default For Each Range in Worksheet

I think what I am going to do is cheat. I am going to put all the
ranges on one sheet, then have the true ranges just equal that sheet.
Then I can just have the code Read Case Select i.row.

Thansk for the insite,
Jay