I have reached an impasse with my limited VBA skills and ask if anybody can figure out this task.
Simply stated, I need to remove all formatting from copied and pasted text into a new document, and to have all text be in one big block of text . If there are text boxes that can be deleted and text copied into the body of the text that would be fantastic -- I also need paragraph spacing to be removed and appended to the end of the previous line of text. I have attached photos of what I need below. It isn't too pertinent that the text be the same format, but if possible to make it 12pt and non-bold italics or underlined that would be fantastic.
I can't seem to get it all to work and I find myself just doing it the hard way anyways.Any help is appreciated, and thank you in advance.
What it looks like upon copy paste:
What I need it to look like after running Macro:
![]()





Any help is appreciated, and thank you in advance.
Reply With Quote
