Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

range.font.bold = true causes error 1004

Status
Not open for further replies.
atmosphere

atmosphere

Programmer
Jul 28, 2003
7
0
0
US
HEy all

Can someone please help

temp = range("somecell")
temp.font.bold = true

this causes run time error '1004'. to be more specific, "Unable to set the bold property of the font class"

Someone please help
 
Sort by date Sort by votes
Hi atmosphere,

To set a reference to a range use ..

Code: 
Set
Code: 
temp = range("somecell")

Enjoy,
Tony
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

morechocolate
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
303
morechocolate
morechocolate
huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
121
strongm
strongm
sxschech
  • Locked
  • Question
For Each Loop works once then gives error 91 2
Replies
19
Views
163
sxschech
sxschech
feipezi
  • Locked
  • Question
Hoe to fix run time error 2147217900 (80040e14) syntax error in Order By clause 1
Replies
6
Views
598
Andrzejek
Andrzejek
f0rg3tfu1
  • Locked
  • Question
VBA Error in Excel
Replies
11
Views
163
combo
combo

Part and Inventory Search

Sponsor

Back
Top