I am writing a simple macro that takes some cell values that I have retrieved
from a separate worksheet and would like to place them in a new location in
another worksheet. Navigating between the worksheets is not a problem but I
am not sure how to query the user to select the destination cell(s) for the
copied values. I would like to do it via a standard mouse click rather than
typing them in a userinput box if possible. Suggestions?