Split row into multiply rows based on combined values in a celland then make the values unique
Minor question....
I'm struckling to get 'OnError resume next' to include (or something like that).
If the cell in column A is empty or there is no splitcode like ";" then the macrocode has to skip this record en go on with the next one.
For example;
A1= AA123;BB123 Then run macrocode
A2= (empty cell, skip running the macrocode take next record)
A3= CC123;DD123 Then run macrocode
A4= EE123 (no splitcode, skip running the macrocode take next record)
regards, Johan
|