Hi everyone. Im wondering how i could go about doing this. Ive setup a UDF
and one part looks like the following. A string is passed (rdText) and if it
contains a comma I need to break up the delimited text, insert however many
rows needed below where the formula is and paste the split up text there.
Thanks in advance

If InStr(1, rdText, ",") 0 Then
For Each iChar In Split(rdText, ",")
If iChar < "" Then
'insert row
'paste value to the new row
End If
Next iChar
End If