In a simple test I could not repro this problem.
What error do you get? Did you delete the named sheet, then try to reference it again?
In a simple test I could not repro this problem.
What error do you get? Did you delete the named sheet, then try to reference it again?
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com
_______