Hi,
I'm creating a simple macro that will go through all relevant cells and checks for leading apostrophe -> adds it if it's missing.
Everything was working fine, but I noticed that my macro changes the formating of whole cell, which is problem.
For example: This is how my text looks. to -> 'This is how my text looks.
Even worse, most of my text is color coded - there are links which are blue, content that is red. After running my macro, everything is in color that has a majority.
I tried to record the macro by manually inserting the apostrophe, but it showed lots of code 'with selection' and then position where red font starts & ends, position where underline starts & ends, etc.
My question is. Are these informations stored in some variable, so I can add the apostrophe and then color the cell the way it was before?
Thanks for your help.
Bookmarks