After serious thinking aditel wrote :
Probably the answer lays here.
It was confirmed on several portals unfortunately...

"The only time you CANNOT use a sheet's CodeName is when you reference a
sheet that is in a workbook different from the one in which the code
resides."

My tests prove otherwise and so I reiterate: Try my suggested approach!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc