I'm constantly creating workbooks (thru Essbasse Cascade function) that
have 50 or more sheets.
I'd like a quick macro to defined a named range on each sheet, using
the tab name as the range name.
Example
I have 3 sheets named "Dallas", "Houston", and "Austin". Id like to
define the range A1:Z200 in each sheet, and name that range "Dallas",
"Houston", and "Austin".
No to bore you with details, but this is important because I use these
named ranges in my Essbase retrieve macros.
Thanks
--
rbanks
------------------------------------------------------------------------
rbanks's Profile:
http://www.excelforum.com/member.php...fo&userid=2944
View this thread:
http://www.excelforum.com/showthread...hreadid=526217