VBA with Excel Problem

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. :mad:

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

Are you sure?

I've been using variable names

VB Code:

Dim tempStr as string
tempStr = "A" + 1
Range(tempstr).blablabla 'works for me