Dim "refrenance to cell text" as integer

[wilg]

I have a statement...

Dim Area as integer

I would like the integer be variable based on the name that can change. Is it possible to refrence the name to a cell text as the integer?

example

Dim Thisworkbook.sheets("book1").range("a1").text as integer

I cant get that one to work.

[patel]

why ? what's the goal ?

[wilg]

I would like my user to be able to change the name of the integer. Right now the integer is an name of a place. I want the user to be able to change the name and the code will adjust to the new name and use that name as the new integer