Your Sub is called CopyAndPasteAsValue, which means you need a place to copy from and a place to copy to. But you only have one cell as an argument. Is that the source or destination? And what is the other one?
Here is an example that may give you enough information.
This sub will copy from Cell and paste to whatever is the active cell selected by the user at the time this is called.
Here is an example of how you can call it:
For a more specific answer, provide more details about what you are doing.
Bookmarks