Rita

on my computer, it is spelt "Arial Narrow". Guess that's what it is on
yours and the root of your problem.

Regards

Trevor


"RitaG" wrote in message
...
Hi,

I'm updating an Excel 2003 spreadsheet dynamically.
I set the font for the current cell I'm working with but the
results do not reflect the font name. The other attributes are correct.
I checked to see if the font name is valid and it is.
Here's my code:
'*** Change the font for just this cell
With Selection.Font
.Name = "Ariel Narrow"
.Bold = True
.Size = 9
End With
I changed the .Name to "Book Antigua" and that worked fine.

Another issue I have is trying to set a different cell to a certain color.
It's just not working. Here's the code (lLastColumn has a value of 33):
'*** Extend the Navy Blue color in row 2, last column created
wshFIC.Cells(2, lLastColumn).Select
Selection.Interior.ColorIndex = 2

Any suggestion will be greatly appreciated!

Rita