VBA code to select multiple cells

[dpaton05]

I want to format 3 cells as currency, what's wrong with this code?

    With Worksheets(Combo)
        .Columns("K5").NumberFormat = "$#,##0.00"
        .Columns("L5").NumberFormat = "$#,##0.00"
        .Columns("M5").NumberFormat = "$#,##0.00"
    End With[CODE]

 

[Joe4]

"K5" is NOT a column reference, it is a range reference.

Try:

[COLOR=#333333]With Worksheets(Combo)[/COLOR]
[COLOR=#333333]    .Range("K5:M5").NumberFormat = "$#,##0.00"[/COLOR]
[COLOR=#333333]End With[/COLOR]