Solved: Giving a name to a Range in Excel?

[jungix]

hi,

I need to use the code that someone else wrote (I can't copy a sample here though).

In his code, he uses a name called "plotratio". I know what it refers to (the range in my worksheet). In some cells he explicitely referred to it: e.g. =MIN(plotratio)

My problem is that I saw nowhere where he set plotratio to be this specific range. I used the find method in Excel and in VBA to find any occurences of "plotratio" but it calls only calls to this name, never a declaration or a Set.

Do you have any idea what kind of data it can be and how to use this?

Thanks,
Jungix

[mdmackillop]

It could have been set "manually" using Insert/Name/Derfine on worksheet. If you're going to use it in your code, remember to wrap it in quotes. =Min("PlotRatio")

[jungix]

Thanks mdmackillop.

I found all the names used in here.

Just so you know (but maybe it depends of my options), it works perfectly well without "" but it doesn't work with them.

[mdmackillop]

It's in code that you need the quotes. eg

Set PR = Range("PlotRatio")

[jungix]

Ok. Thanks again.