1) Is there a limit to the number of named ranges a worksheet can have?

2) I don't really need a macro to perform a copy, however, it is a very
good example of my actual problem.

2A) I would like the user to place the cursor where the text is to be
copied from and click a button to invoke the "copy macro". Once this macro
is invoked it would read the contents of the activecell and then re-prompt
the user for a cell of where the text is to be coppied. Once the user
CLICKED on this cell the macro would copy the value of the first cell into
the second.

Thanks in advance,