Check these out:
https://docs.microsoft.com/en-us/off...cel.range.copy
https://docs.microsoft.com/en-us/off...e.pastespecial

So, it seems to me that you want to first Copy the R8:R300 range and the PasteSpecial (with the xlPasteValues option).

Here is a tip. Use 'Record Macros' to auto generate the code on how to do something you do manually. You probably know how to do this with various button clicks and selections. Recording a macro will usually get you on the right path (although it is usually not the most dynamic or efficient code).