Split values in Cell D onto next line??

My Excel spreadsheet is setup like this:

Cell A Cell B Cell C Cell D
John Smith Yes Alberta,Ontario,Quebec

How can I code it so that I can turn that into this:

Cell A Cell B Cell C Cell D
John Smith Yes Alberta
John Smith Yes Ontario
John Smith Yes Quebec

Basically take the values in Cell D (where there is a comma) and it add to the next row containing the other values in Cell A, B, and C

Help is appreciated.....

Johnny

THe basic idea would be:
Read in your line (each cell in a StringVar).
split the String in Cell D into a StringArray. If this array has only one item, just refill the line again, if it has more items fill a line with all the StringVars and in Cell D just one of the StringArray-items at a time (you need to insert a line for all the additional items).