View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
clara clara is offline
external usenet poster
 
Posts: 252
Default Global name used in local version

Hi all,

I define a global scope name, It works fine for all the other worksheets
except one.
in the error worksheet, I can see the global name in the formula bar
dropdwon, when I click it, I am lead to the right location on the right
sheet, but when I use the name as a validation on a cell, I am lead to a
location on this error worksheet but with the correct row and column number

Clara
--
thank you so much for your help