Change font of row cell reference characters
 

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

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

Change font of row cell reference characters
 

Works great!

Thanks,
Mike