It works (obviously, it's from Greg).
I would never have worked that out in a month of Sundays.
So the first "trick" is to save the table as a Range instead of a Table, and the second is to use the FormattedText attribute.
Now I know why I never worked for Microsoft - my mind isn't sufficiently agile (or should that be "warped"?).
Thanks again Greg!
|