[ExcelVBA] excel vba for each loop in multiple ranges

 

I watt to perform some operations on each cell in a range named range1 and then the same operations on all cell in range named range2 and furter on..

i can of course code this like

for each cell in range1
..
..
..
next

for each cell in range2
..
..
..
next
and furter on, but is there a simpler/more elegant way to do this.?

I can not perform this on a union of ranges, it has to be done on each range separetely.

regards

Torstein

__._,_.___

---

Posted by: Torstein Johnsen <sejohnse@yahoo.no>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
------------------------------------

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___