How to add one more field into the macro.
Sorry for asking silly questions as I am dummy trying to learn macro.
I want to add one more field, something that i want to copy from the specific source and paste it somewhere else.
Questions are how to identify and index the source to copy.
In my case the source is assignee of patents ie. athena neuroscience that is a paragraph away from lngStart. I want to copy the text and paste it to simultaneously after each cell of arraylist.
I want also to remove paragraph mark from column IV marked blue.
|