Having had time to think about it, I assume you mean when you manually enter a value into a cell in column A rather than paste something in.
The problem there is this line:
When you enter a value in a cell then hit enter to confirm it, the selection moves to another cell (either below or to the right dependent on your setup) so your variable selectedRange is set to an empty cell and this causes issues when you're trying to name a sheet as you cannot give a sheet no name.
You can test this by entering a value in a single cell and confirming it with Ctrl+Enter so the cell selection doesn't change.
Your code would also benefit from some error handling. If the user changes a cell value to nothing by deleting the contents of a cell it will also throw up an error.
BSB
Bookmarks