Change the Font Style in VBA

  • Thread starter Thread starter justme0010
  • Start date Start date
J

justme0010

What am I doing wrong? I am trying to change the font style of cells
with text values in them but they still all show up as Arial. The font
size, bold, and alignments work, though. Why not the style?
 
ActiveCell.Font.Name = "Century Gothic"
'--

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"justme0010"
wrote in message
What am I doing wrong? I am trying to change the font style of cells
with text values in them but they still all show up as Arial. The font
size, bold, and alignments work, though. Why not the style?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combining a string of text 3
Using VBA to rearrange data 0
How to write a formula to set the Font Style? 2
Word Word 2007 Styles 0
Font Styles Not Showing Up 3
XIRR Help 0
Excel 2007 Problem Paste/Enter Key 0
How to count number of Cell have Strike Through Effect & Bold as font style. 6

Back
Top