Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,593
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
copy contents including colour gramps Excel Discussion (Misc queries) 3 May 1st 10 12:35 PM
Excel:Swap cell contents-including cell groups-betwen 2 locations Rob R Excel Discussion (Misc queries) 0 February 6th 08 11:13 PM
Protect Cell Formatting including Conditional Formatting Mick Jennings Excel Discussion (Misc queries) 5 November 13th 07 05:32 PM
Setting one cell = to another, INCLUDING FORMATTING. manxman Excel Discussion (Misc queries) 0 May 5th 06 05:20 PM
How to create a link including all formatting from origin cell? PlatinSam Excel Worksheet Functions 2 January 17th 06 06:45 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"