Okay, all my VB is self taught so this might seem like a really stupid
question. I do a lot of variable declarations to use in my code and I need
to use those variables as cell references and also be able to use it as an
integer. Is there some expression that I can use to say use the string of
variable X?

I saw a reference somewhere about using something like what I want but it
was for OLAP stuff. I primarily use VB in excel/access.

Currently what I do is:
Dim X as integer
Dim XStr as string
x = 0
XStr = X

Seems really redundant.