Very Computer

Marco

: If within a macro I define a cell name to point to a specifid cell and
: (let say cell A1B1 with the name STR) and I want to get the value of the
: cell content or better what's in the cell, how can I do?
: Let's say that the macro scroll across different cell and name them STR
: one after the others. For each loop I want to know the contents of the
: cell. Please note that the content can be a number or a text.
: Please reply to my e.mail address.
: Thanks

Hi Marco,

I don't have Excel 7.0 but any of the following worked in Excel5:

Range(Names("Str").Name)
Range(Names("Str").Value)
Range(Names("Str").Value).value
Range(Names("Str").RefersTo)

and Range("Str") sometimes worked, sometimes not. I didn't pay
attention to figure out why 'cause I have the above alternatives.

Hope this help.

Runsun Pan
Biol Sci Purdue Univ