View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
RoyWollen RoyWollen is offline
external usenet poster
 
Posts: 3
Default Named ranges interfere with simple formulas

I am my own worst enemy. I created a macro that utilizes named ranges when
it creates spreadsheets. If my users want to create their own formula and
inadvertently use my named range, the results are incorrect.

A simple formula they'd put in such as =d3/c3, becomes =d3/RoysNamedRange.
of course, when they copy this formula down a column, =d4/RoysNamedRange is
not a relative reference and is incorrect.

What can I suggest?