ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Change Font Type (https://www.excelbanter.com/excel-programming/281387-change-font-type.html)

Brady Snow

Change Font Type
 
I am trying to change the font type of all the cells to
arial with out changing the size, bold or other formating
options. Is there a way to do this through a macro?

Thanks,

Brady Snow

Mckinney, Tx

[email protected]

Change Font Type
 
This will change all cells in the ActiveSheet.

Cells.Font.Name = "Arial"

Or you could just click on the 'box' to the left of Column A and above
Row 1. Change by selecting on Menu Bar, Format Cells Font Tab.

HTH
Paul
--------------------------------------------------------------------------------------------------------------
Be advised to back up your WorkBook before attempting to make changes.
--------------------------------------------------------------------------------------------------------------

I am trying to change the font type of all the cells to
arial with out changing the size, bold or other formating
options. Is there a way to do this through a macro?

Thanks,

Brady Snow

Mckinney, Tx




All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com