I'm trying to write a macro which searchs for a comma in every cell in column A.

If a comma is found in the cell it is suppose to duplicate the row and insert it just below.

So if the string in cell A5 is "5562288851, 5562030576", row 5 should be duplicated and inserted between row 5 and 6. And this should be checked on all rows containing data in column A.

The SEARCH/FIND-functions does not work in VBA, how am I suppose to make this possible?

Thanks in advance, a happy hobbyist from Sweden.