Copy Paste help

[davistax]

I have a macro that selects the value of the activecell & pastes elsewhere in the same sheet.
What I need now is to have the user to select a different sheet & click on the cell that he where he would like that value pasted. This seems simple, but I am at a loss as to how to pause the macro while the user chooses the destination cell.

Any assistance would be greatly appreciated.

 

[Joe4]

If you have to select the cell, trigger the macro, then go another sheet and select the cell that you want to paste to, why not just use Excel's built-in Copy/Paste functionality (CTRL+C, CTRL+V)?
It doesn't seem like you are really saving much to create a macro that pretty much re-creates existing functionality.

 

[davistax]

The macro will be doing some calculations while that takes place & the result will be pasted beneath the destination cell. The destination cell is decided by the user.

 

[Joe4]

Ah, okay. That makes sense. There is more to it.
See if this is what you are looking for: VBA code to prompt user to select a cell

 

[davistax]

Yes, I can make that work. Thank you very much. That is simple. Not sure why I was hung up on it

 

[Joe4]

You are welcome.
Glad I was able to help!