Find last row of Data for Column F & make formatchanges

[LNG2013]

I need to find the last row of data where there is data in Column F. I then need to select from that row the cells that pertain to A, B, C, D, E, F, G, H, I, J, K, L, & M and then be able to make format changes like increase font size.

I also then want to select A in that same row and put the word Total.

 

[AlphaFrog]

Sub test()

    Dim Lastrow As Long
    
    Lastrow = Range("F" & Rows.Count).End(xlUp).Row
    
    Range("A" & Lastrow).Value = "Total"
    
    With Range("A" & Lastrow & ":M" & Lastrow)
        With .Font
            .Name = "Arial"
            .FontStyle = "Bold"
            .Size = 10
            .Strikethrough = False
            .Superscript = False
            .Subscript = False
            .OutlineFont = False
            .Shadow = False
            .Underline = xlUnderlineStyleNone
        End With
    End With
End Sub