Need to concatenate with last rows

[aravindh8686]

Hi ,
I need to concatenate Row C value with its last cell value one another one in a below format and paste the output in Row D. Multiple files I have, so the number of rows will increase for each workbook.

For Eg:

C D

001 0001 OF 0005
002 0002 OF 0005
003 0003 OF 0005
004 0004 OF 0005
005 0005 OF 0005


kindly help me with a macro,

Presently I am using below syntax to concatenate with next cell , If it is possible to edit the below syntax as per my above requirement kindly suggests.

LastRow = Cells(Rows.Count, "M").End(xlUp).Row
Range("O1:O" & LastRow) = Evaluate("""0""&M1:M" & LastRow & "&"" OF 0""&N1:N" & LastRow)