Make text partly bold, but failed

**vdongen** · 10-10-2010, 01:36 AM

How to get only the first string bold and not the remaining text? At this stage all is bold.

Please Login or Register  to view this content.

**Marcol** · 10-10-2010, 06:31 AM

You need to specify the cell you need to make partially bold

Please Login or Register  to view this content.

Change A1 to suit your needs

Hope this helps

[EDIT]
You will need to add this line to the with statement if your code is to run more than once

Please Login or Register  to view this content.

**vdongen** · 10-10-2010, 08:17 AM

I have it worked, but after selection, the proram has to go to all cells to ClearFormat which takes 3 seconds. Any faster solution?

Please Login or Register  to view this content.

**Marcol** · 10-10-2010, 08:28 AM

As I said, add

Please Login or Register  to view this content.

to the With statement

Please Login or Register  to view this content.

Hope this helps

**vdongen** · 10-10-2010, 09:02 AM

I did, but then merging will not proceed. The code is part of a bigger command.

Please Login or Register  to view this content.

**Marcol** · 10-10-2010, 09:05 AM

Where does merging cells come from?

Best you show a bit more of your code.

Re: Make text partly bold, but failed