Get Cell Contents Including Formatting
Hi,
Is there a way to get and set the content of a cell such that you also get the formatting characters used? For example, if I have the string "Test this out" and I manually set "this" to bold (using ctrl-b with "this" selected) is there a property that would return something like "Test <bthis</b out" ? If so, is there a way to set that back? I'm aware of the Characters property but I'm hoping I don't have to resort to that. Thanks! |
Get Cell Contents Including Formatting
I think that Characters is your only way.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ps.com... Hi, Is there a way to get and set the content of a cell such that you also get the formatting characters used? For example, if I have the string "Test this out" and I manually set "this" to bold (using ctrl-b with "this" selected) is there a property that would return something like "Test <bthis</b out" ? If so, is there a way to set that back? I'm aware of the Characters property but I'm hoping I don't have to resort to that. Thanks! |
All times are GMT +1. The time now is 05:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com