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