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"
Range(Cells(LastRow, "F"), Cells(LastRow, "Q")).NumberFormat = "$#,##0.00"