Arial 10 to macro

[flamme20]

The situation is that I copy certain data based on criteria using macro in the same workbook from one sheet to another, like this:

Sheets("Sheet1").Select
Range("C" & CStr(LSearchRow)).Select
Selection.Copy

Sheets("Sheet2").Select
Range("F" & CStr(LCopyToRow)).Select
ActiveSheet.Paste

but the format between these two sheets differs. In Sheet 1 I have Arial 16, in Sheet 2 I have Arial 10.
Can I possibly add the line to the macro which would allow formatting from Arial 16 to Arial 10 without me interfering?
Can someone suggest me pls?

 

[Michael M]

Sheets("Sheet2").Select
Range("F" & CStr(LCopyToRow)).Select
ActiveSheet.Paste
    With range("F" & CStr(LCopyToRow)).Font
        .Name = "Arial"
        .FontStyle = "Regular"
        .Size = 10
        .ColorIndex = xlAutomatic
    End With

 

[flamme20]

Sheets("Sheet2").Select
Range("F" & CStr(LCopyToRow)).Select
ActiveSheet.Paste
    With range("F" & CStr(LCopyToRow)).Font
        .Name = "Arial"
        .FontStyle = "Regular"
        .Size = 10
        .ColorIndex = xlAutomatic
    End With

Thank you, Michael M, now everything's alright!