VBA Chnage Font Properties

[hobbiton73]

Hi, I wonder whether someone can help me pleaese.

Firstly my apologies for such a simple question, but I've tried all sorts of solutions to get this to work.

Could someone possibly tell me please how I would change the font to "Calibri Size 12" in the code below please.

Please Login or Register  to view this content.

Many thanks and kind regards

Chris

[ashishmehra2010]

Hi Chris,

Please check the attached file.

[hobbiton73]

Hi @ashishmehra2010, thank you very much for this, but I was actually wanting to change the font for the whole range i.e out of the If statement.

Kind Regards

Chris

[Philb1]

This should do it

Please Login or Register  to view this content.

[hobbiton73]

Hi @Philb1, that's great, thank you very much. It works perfectly.

Kind regards

Chris

[Philb1]

That's good
Cheers
Phil

[ashishmehra2010]

Thanks for the rep Chris