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.
|