View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bert[_3_] Bert[_3_] is offline
external usenet poster
 
Posts: 7
Default loop through all named ranges

I have a set of named ranges in a worksheet that are spread out
through the sheet. I need to loop through the ranges, with the
intention of copy the values and pasting them in another workbook.

Any suggestions?