you can put the sheet name in front:
=SMALL(Sheet5!Fri_10,1)
Or you make global scope names:
Regards
Claus B.
--
Small addition to the code with: ActiveWorkbook.
Will make it much easier to install formulas on the master sheet.
Thanks.
Howard
I disagree! Using global scope will almost certainly cause name
conflicts if you need to copy sheets to another workbook. (Whether the
names ref the copied sheets or not since, by default, all global scope
names tow along with any sheet from that workbook!) Also, since global
scope isn't required to use the name in formulas then it's just NOT
'best practice' to give them global scope!
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic
VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion