Okay, so I should do the naming using Define Name where I can select
the sheet name from the Scope drop down.

Seems to me the default is *fully absolute* as the name always shows
up in the name manager $A$1:$A$5...

I think I'm getting more or less what you are saying, just need to
start trying to use it more often.

Howard

Yes, fully absolute is the default ref type. You'll have to manually
configure if you want to use one of the other ref types.

For fully absolute refs you can just type in the Namebox left of the
FormulaBar. Just remember to prepend the sheetname as shown for
assigning local scope. Note that if there's no spaces in the sheetname
then the apostrophes are not required.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion