Format Columns As Currency

[jo15765]

I am attempting unsuccesfully to format only a few columns as currency. My syntax formats all cells in the worksheet which is not what I am after. This is the syntax I have tried, what should I update in order to ensure only columns C - H are updated to currency format?

Cells.Select
Cells.EntireColumn.AutoFit
Range("A1").Select


Columns("C:H").Select
Selection.NumberFormat = "$#,##0"
Range("A1").Select

EDIT - I forgot to mention that stepping through my code, the line

Columns("C:H").Select

Selects my entire used range not <strong>ONLY</strong> columns C - H

 

[Momentman]

There's no reason why that last line should select all your columns.

In any event, you dont need to select a range to perform an operation on it so

Columns("C:H").NumberFormat = "$#,##0"

That works for me

 

[jo15765]

That got it, thank you!

 

[Momentman]

You are welcome. Thanks for the feedback