VBA Format cell of last row in every other column

[Worker8ee]

The following VBA line work for changing the last row cell of columns F through Q to a $ number format but I'd like to only do this for every other column. I could obviously write it out line by line and have 12 lines but there has to be a more simple way, perhaps something I can add to just this one line?

Range(Cells(LastRow, "F"), Cells(LastRow, "Q")).NumberFormat = "$#,##0.00"

 

[Peter_SSs]

Here are two ways

Intersect(Rows(LastRow), Range("F:F,H:H,J:J,L:L,N:N,P:P")).NumberFormat = "$#,##0.00"

Range(Replace("F#,H#,J#,L#,N#,P#", "#", LastRow)).NumberFormat = "$#,##0.00"

 

[Worker8ee]

Very cool Peter thank you for writing that, it's helping me think in more efficient terms when writing the commands. Your input helps a lot thanks for taking the timd to reply!

 

[Peter_SSs]

You're very welcome.