Solved: how range is defined for a worksheet?

[maryam]

I have this exel file with one worksheet. In the codes wriiten in the module there are:
.Temperature.SetValue Range("FeedTemp").Value, "C"
.Pressure.SetValue Range("FeedPres").Value, "bar"
.MolarFlow.SetValue Range("FeedFlow").Value, "kgmole/h"

I am confused how does FeedTemp replace for C15? where is it defined that FeedTemp is C15?

[johnske]

Those are 'named ranges'. Go into Insert > Name > Define and you'll see the named ranges there (for more, read Help about this)

[maryam]

thank you. now I can understand.

[mdmackillop]

For all you need to know about Range Names (http://xldynamic.com/source/xld.Names.html)(and maybe a bit more)

[Bob Phillips]

:)

[Bob Phillips]

One other point, Name Management in Excel is absolute garbage. Even 2007 with its so-called Name Manager function is rubbish.

But luckily, there is a much better tool out there, and best of all is that it is free. You can find it at my good friend Jan Karel Pietrse's site, at http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp (http://www.jkp-ads.com/OfficeMarketPlaceNM-EN.asp)