Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy contents including colour | Excel Discussion (Misc queries) | |||
Excel:Swap cell contents-including cell groups-betwen 2 locations | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Setting one cell = to another, INCLUDING FORMATTING. | Excel Discussion (Misc queries) | |||
How to create a link including all formatting from origin cell? | Excel Worksheet Functions |