using a cells value as part of vba formula

Hi,
I need vba to perform a match function in one cell and to then use the value produced in this cell to identify the row from which to copy a number of cells.

Getting vba to write the match code into a cell is no problem, but how do i then use this value as the row number in the below range( ).select

something like... range("R"& cell(A10).value"C2:R"& cell(A10).value"C11").select ...only this doesn't seem to work

  Range("A10").Select
    ActiveCell.FormulaR1C1 = _
        "=MATCH(R[-7]C[10],'Competitors and Irradiance'!C[12],1)"
   
    Sheets(1).Select
    range("R"& cell(A10).value"C2:R"& cell(A10).value"C11").select
    Selection.Copy

thanks in advance for any help with this