Sonia Bowditch
asked on
Unable to get the Search property of the WorksheetFunction Class
Hello Experts,
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.
Regards,
InfoSec36
WorksheetFunction-Class-error.xls
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.
Regards,
InfoSec36
WorksheetFunction-Class-error.xls
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Byndt, works perfectly as usual. Thank you.
Ken, I will be able to utilise your solution in my other analysis worksheet.
Regards,
InfoSec36