If i try to name cell D6 to pSP5 it jumps to cell PSP5.
Are you specifying 'local scope' (sheet level)? PSP5 is probably global
scope (workbook level) and so takes precedence. You should never create
global scope names unless *absolutely* necessary! You can ref a name on
another sheet by prepending the sheetname like so...
='Another Sheet'!NamedRange
...where "NamedRange" refs the range defined with local scope on
Sheets("Another Sheet").
--
Garry
Free usenet access at
http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion