View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lluis Escude Lluis Escude is offline
external usenet poster
 
Posts: 6
Default Named range in a sheet referred to from another sheet

It works, thanks a lot.

Still I'd like to know what was wrong with my syntax: I asume my named range
was "global" for the entire workbook and not just for the sheet the specific
cell was in.

I have loads of code lines using

Range(ThisWorkbook.Names(...

so I wonder if I should change them -as well as new references yet to be
written- in accordance with your suggestion, and so avoid trouble in the
future.