View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg Greg is offline
external usenet poster
 
Posts: 331
Default looping thru named ranges

Hi,

I have a bunch of pairs of named ranges, all of them consist of some
leading identifier followed by LIVE or HARD, for instance spLIVE, spHARD;
RussellLIVE, RussellHARD, etc.

How would I loop through the range collection and copy/ paste values each
LIVE range into respective HARD range?

Thank you,

--
______
Regards,
Greg