How to change the format of a given range?

[inddon]

Hello There,

I have the below code which makes the colour of the cell to Automatic, only when the cell or range is selected

Range("DNumberOK").Select
With Selection.Font                              'Make Font Green
         .ColorIndex = -16776961
         .TintAndShade = 0
       End With

I would like to give the name of the range instead, as below code, so I don't have to select individual cells. Is this possible?

I tried something below, which doesn't work

With Range("DNumberOK").Selection.Font   'Make Font Green
         .ColorIndex = -16776961
         .TintAndShade = 0
       End With

Thanks & regards,
Don

 

[Marc L]

Hi !

Logically just remove .Selection …​

 

[inddon]

Thank you Marc