Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# bold in a text in a string

Posted on 2014-02-24
Medium Priority
142 Views
Hi,

I have the following problem

cells(1,1).value = "This is a TEST of values"

My problem is that i want that in the cells(1,1) appear the word "TEST" in bold something like that "This is a TEST of values"
0
Question by:joyacv2
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
1 Comment

LVL 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 39883133
You can set bold at the character level.  Using your example:

``````cells(1,1).characters(11,4).font.bold=true
``````
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…
###### Suggested Courses
Course of the Month9 days, 16 hours left to enroll