VBA code error

[jakobt]

Writing this code:
Receives error: Compile error - Method or data member not found.

Sub Sizing()




Range("a1:J125").Select
With Selection.Font
.Name = "Arial"
.size = 8

End With
End Sub

 

[JackDanIce]

Is that the full code? You don't need .Select, this works on a new sheet just tested on:

Sub Sizing()

With Range("A1:J125").Font
    .Name = "Arial"
    .Size = 8
End With

End Sub

 

[mohan.r1980]

may be

 sheets("sheet1").Range("a1:J125").Select

 

[JackDanIce]

Mohan, that will generate a run time 1004 error if Sheet1 is not the active sheet

 

[jakobt]

When running this code: Get the error:
Compile error: Ambigorous name detected: Sizing.

(Saved the code in personal macro book and run it from here). Is it possible to adjust the code so it can be stored and run from the personal macro book.

 

[JackDanIce]

You have two macros with the same name "Sizing" it doesn't know which macro to compile