On 03/09/2014 15:42, RussellMc wrote:
> Method
>
> Create a sheet as required.
> Name the sheet with a simple name for now, such as AAA.
> When creating names that will be local to the sheet using 'Insert Name
> Define', instead of naming them eg Income,name them AAA!Income, where AAA
> is the sheet name.
> When finished and ready to clone the sheet.
>     Highlight all (Ctrl A)
>      Copy (Ctrl C)
>     Swap to target sheet
>     Highlight all OR move to cell A1
>     Paste (Ctrl V)
>
> Done
If you want to clone a sheet press the right mouse button on the sheet name=
,
select "Move or copy...", in the following dialog  check the checkbox!


> Local variables specific to THIS sheet now exist
>
> Using Insert Name Define to display the name define menu shows global nam=
es
> as before PLUS local names with SheetName!  in front of the variable name
>
> WARNING:  If you define a global name eg Yoda, and then create  SheetN!Yo=
da
> in a sheet, and then copy the whole sheet contents to a new blank sheet,
> you will wish that you hadn't :-).
Good warning: Excel doesn't warn you :-(
You can distingue global from local names within the Define name dialog bec=
ause
in the right of the name list you see the sheet name for local names.

> Many thanks to all. I'll know if there are any other fish-hooks shortly.
> =20
I love Excel! Started with formulas and macros in the middle '80 with Lotus=
 123
and Simphony...
           Nic

--=20
http://www.piclist.com/techref/piclist PIC/SX FAQ & list archive
View/change your membership options at
http://mailman.mit.edu/mailman/listinfo/piclist
.