Andreas Hermle
asked on
add a manual line break before each and every substring that starts with 'X0' using VBA
Dear Experts:
I would like to run a macro on selected cells that perform the following action:
The macro is to add a manual line break before each and every substring that starts with 'X0****'
The macro is to run these actions in the cell itself not copying the cell contents to the right and perform the action there.
The cell height has to be adjusted depending on the number of line breaks that get inserted.
Help is very much appreciated. I have attached a sample file for your convenience.
Regards, Andreas
Insert_manual_link_break_before_eve.xlsx
I would like to run a macro on selected cells that perform the following action:
The macro is to add a manual line break before each and every substring that starts with 'X0****'
The macro is to run these actions in the cell itself not copying the cell contents to the right and perform the action there.
The cell height has to be adjusted depending on the number of line breaks that get inserted.
Help is very much appreciated. I have attached a sample file for your convenience.
Regards, Andreas
Insert_manual_link_break_before_eve.xlsx
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
As a matter of fact you both deserve 1000 points. Great job from both of you. I really appreciate it. Regards, Andreas
T H A N K Y O U very much
T H A N K Y O U very much
You’re welcome and I’m glad I was able to help.
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
If you expand the “Full Biography” section of my profile you’ll find links to some articles I’ve written that may interest you.
Marty - Microsoft MVP 2009 to 2017
Experts Exchange MVE 2015
Experts Exchange Top Expert Visual Basic Classic 2012 to 2017
Open in new window