RWayneH
asked on
Dynamic VLOOKUP formula in VBA procedure
Hello
I have a need for a dynamic VLOOKUP formula within a vba procedure.
I am using, ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-37],Inventor y!C[-14]:C [-5],10,FA LSE)"
The dynamic part is the [-37] which refers to column A.
How would I change the formula to point to Column A, no matter the cell that the formula gets put into, so it honors the proper value being used in the VLOOKUP?
Please advise and thanks.
I have a need for a dynamic VLOOKUP formula within a vba procedure.
I am using, ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-37],Inventor
The dynamic part is the [-37] which refers to column A.
How would I change the formula to point to Column A, no matter the cell that the formula gets put into, so it honors the proper value being used in the VLOOKUP?
Please advise and thanks.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER