Run time error 13 Type mismatch in VBA

  • One of the VBA sentence in my existing code is

    Dim lngRows As Long 
    Cells(lngRows, "Q").FormulaR1C1 = _

    while executing the Macro, i get error 13 Type mismatch

    What i need to change, so that, i dont get error, and it gets executed.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!