PDA

View Full Version : Dim "refrenance to cell text" as integer



wilg
11-20-2012, 04:54 AM
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
11-20-2012, 05:27 AM
why ? what's the goal ?

wilg
11-20-2012, 05:54 AM
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