buhay
12-02-2010, 12:02 PM
Does anyone one know how I can delimit serveral cells of ColC filled with several e-mails seperated by ";" and place each e-mail in the rows below?
For example before executing the macro
------------ColC----------
row1 ------E-Mails-------
row2-aa@aa.com;bb@bb.com;cc@cc.com
row3-dd@dd.com;ee@ee.com;ff@ff.com
row4-gg@gg.com;hh@hh.com
row5-ii@ii.com
Result after executing the macro
----------ColC----------
row1 -----E-Mails-------
row2-aa@aa.com
row3-bb@bb.com
row4-cc@cc.com
row5-dd@dd.com
row6-ee@ee.com
row7-ff@ff.com
row8-gg@gg.com
row9-hh@hh.com
row10-ii@ii.com
Any help is hightly appreciated
For example before executing the macro
------------ColC----------
row1 ------E-Mails-------
row2-aa@aa.com;bb@bb.com;cc@cc.com
row3-dd@dd.com;ee@ee.com;ff@ff.com
row4-gg@gg.com;hh@hh.com
row5-ii@ii.com
Result after executing the macro
----------ColC----------
row1 -----E-Mails-------
row2-aa@aa.com
row3-bb@bb.com
row4-cc@cc.com
row5-dd@dd.com
row6-ee@ee.com
row7-ff@ff.com
row8-gg@gg.com
row9-hh@hh.com
row10-ii@ii.com
Any help is hightly appreciated