I have been using Range("Cellvalue").Formula and similar for a while, but I found I can't use variables as the cell references, only text.

Is there a similar cell selecting/editing/value grabbing function that I can use instead