jungix
08-07-2006, 10:06 AM
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
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