Can I use a name twice in a workbook, only in different sheets? That is to
say can I have Name "Area1" for "Sheet 1!$A$1:$F$10" and also have Name
"Area!" for "Sheet2!$A$1:$F$14"

I tried the above but it didn't work. I'm not sure if it can't be done or I
did something wrong.

Thanks for the help..