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
|