Try this:

Sub fnt()
Range("A1:L1").Select
Application.Dialogs(xlDialogFormatFont).Show
End Sub


"lwm" wrote:

I am trying to use this to format a range.

ActiveCell.Range("A1:L1").Select
Application.Dialogs(xlDialogActiveCellFont).Show Arg3:=0


But it only format the first cedll in the range. How do I get this to
change all cells in the range?

Thanks