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