| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formating parts of a cell
I am trying to change the font of only part of a cell. After locating text
in a cell through find, I would like to take part of that cell and change the font. The text I would like to change is at the same but the start location is different. I was planning on after using the find fucnntion in VBA to use the following function to change part of the cells font With ActiveCell.Characters(Start:=X, Length:=4).Font The only problem is that I need to figure out how to define X. Any ideas on how to locate the text "(u" in a cell and record its starting position? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to split 1 cell to 2 parts? | Excel Discussion (Misc queries) | |||
| Copy parts of cell | Excel Discussion (Misc queries) | |||
| How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
| hiding parts of a cell | Excel Discussion (Misc queries) | |||
| deleting certain parts of a cell | Excel Programming | |||
Threaded Mode
