I have a complex VBA macro. It works great. And yet, one line of code is beyond me. I'm trying to make every cell in my active sheet Arial size 10. My code is not working. The sheet comes out Calibri-Bold-10. Here is my code. Has to be simple. Guess simple is above my pay grade. Thanks in advance.
ActiveSheet.Cells.Font.Name = Arial
ActiveSheet.Cells.Font.Bold = True
ActiveSheet.Cells.Font.Size = 10
Application.ScreenUpdating = True
Just after the above code, I save the workbook (single-sheet workbook) to a new .xlsx name, and close the existing macro workbook without saving it
ActiveSheet.Cells.Font.Name = Arial
ActiveSheet.Cells.Font.Bold = True
ActiveSheet.Cells.Font.Size = 10
Application.ScreenUpdating = True
Just after the above code, I save the workbook (single-sheet workbook) to a new .xlsx name, and close the existing macro workbook without saving it
Last edited: