Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Styles in a cell
hi, i have a problem with changing the styles in the cells. Suppose a cell contains some text, say "<F<Center 354<N<F<UTest String<G<N" where, the text between <F and <N are made bold and the text between <U and <G are made underline. This i want to make it through the VBA Code. The text with bold and underline style can be done individually, but the thing is when there is a combination of both, it doesn't happen. All the previous styles are taken off from the cell and only the underline style remains... Finally, the cell content shud be <CENTER 354[/b][b]_TESTSTRING_ Can anyone help me out with this issue?? Again, all this have to be done with VBA.. Thanks and regards, Sriram -- sriramp777 ------------------------------------------------------------------------ sriramp777's Profile: http://www.excelforum.com/member.php...o&userid=34595 View this thread: http://www.excelforum.com/showthread...hreadid=543673 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Styles on Ribbon | Excel Discussion (Misc queries) | |||
some unknown Cell styles are shown in cell styles | Excel Worksheet Functions | |||
Excel Cell Styles - Quick Styles? | Excel Discussion (Misc queries) | |||
New Cell Styles | New Users to Excel | |||
Different Styles within a single Cell | Excel Programming |