Gave the code referenced in the below link a whirl, but I'm getting this
error: "Cannot define a Public user-defined type within an object module".
Don't know enough VBA to be able to correct it. Any ideas?
Thanks.
"Dave Peterson" wrote:
I think you'll have to look at each character and keep track of the font (and
all the other attributes???).
You may want to try this:
http://groups.google.co.uk/group/mic...ee5401f618fd94
or
http://snipurl.com/14omr
Tony Logan wrote:
Let's say the content of a cell is something like this:
<tagabc</tag <tagdef</tag
And let's also say that strings "abc" and "def" are a different font than
the tags. Let's say the tags are Times New Roman while the strings between
tags are Arial.
When I do a find and replace to delete the space between "</tag <tag", the
font of my strings changes from Arial to Times New Roman.
Is there a way to prevent this from happening?
Using Excel 2003.
--
Dave Peterson