In the meantime I found a work around to the problem  (always more than one
way to do things). What I have done is to add a new worksheet  in the
position I wanted to copy  the old one. I then copied the data from the
original worksheet (cells.select, copy) and then used a similar command on
the new worksheet (cells.select) so I am selecting the entire worksheet. I
then use Paste special to paste all the information from the old worksheet
to the new one. I then go back  to the old worksheet and use paste
special.values to clear out all the formulas on the old worksheet.



Using this method, with several additional steps that wouldn't be needed if
the "right" method worked, I am able to do what I need.



Please look at the old file and see if you can find  what is needed so I
don't run into this problem the next time  I want to copy or move  a
worksheet. Since I found a method that works  I can at least put this
problem on the back burner and finish other problems I have.



Thanks to all for the suggestions  and help.



I did download the suggested utility for finding named ranges but need to
work with it more to understand what it is trying to tell me.