I have a macro kindly written by byundt which is designed to look at a column E which contains a message. The macro would then search through the message cell and extract each of the lines and then put them into columns under the correct headings.
When I now run the macro I keep getting the "Unable to get the Search property of the WorksheetFunction Class". I have worked out that it is caused by running into a blank cell.
Could anyone help me configure the macro to move on if encountering any blank cells? I have tried to figure out a way myself but just end up breaking the macro completely.
I have attached an example of the macro and data for your review.