Copying data from specific cells in multiple Workbooks in a folder and Consolidating it

Hi Guys
I have a macro which I have found and it works really well except I have 2 issues

1 - The code only copies formulas and not just plain values
2 - I cant work out how to make it copy from specific cells

Where it says
lngrow = lngrow + 1
ws.Rows(2).Copy ws1.Cells(lngrow, "A")

I want to change that to copy the values from c65 & c67. I have tried altering the lines to try and copy a range but whatever I do it doesnt work. I am new to VBA and have also been trying to find definitions of VBA commands and codes but those commands do not seem to be in anything I have read. I understand lng is there because VBA recognises row as a command but other than that my knowledge is very limited. Any help on this would be greatly appreciated thank you

The code I am using is:

Please Login or Register  to view this content.

Thanks heaps for that it worked a treat