View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Joerg Joerg is offline
external usenet poster
 
Posts: 138
Default Change font of row cell reference characters

Maybe:

Sub AllArial()
ActiveWorkbook.Styles("Normal").Font.Name = "Arial"
End Sub

Cheers,

Joerg Mochikun

"White Horse" wrote in message
oups.com...
On an Excel worksheet, I need to programatically change the font of
the row and cell reference characters ( the A B C at the top and the 1
2 3 down the side).

We programatically process Excel files sent to us. All of our
worksheets are using an Arial font for the cell reference characters.
Sometimes, we receive a worksheet that appears to be using a Courier
font. This causes some fields to display #### when the workbook is
opened.

All of the actual cells in the offending workbook are Arial - it is
only the Reference characters that are different.

We are using Windows XP with Microsoft Office 2003.

Thanks,
Mike