How to Pause macro to allow user to select a cell.

How to pause a macro to allow user to select a cell

Requirement:

The user needing to copy a range of data from one workbook to another. The copying part is easy, but for pasting, the user needs to pause the macro, ask the user to select the top left cell for pasting the data. Then the macro will paste the data that has been copied using the top left cell selected by the user. How does the user allow the user to select a cell and have that cell then be used as the place for pasting (the user needs to paste VALUES due to formatting differences).

https://www.ozgrid.com/forum/forum/help-forums/excel-vba-macros/1193392-pause-macro-to-allow-user-to-select-a-cell

Solution:

If you are interested in the Paste portion ...

You could test the following :

Code:

Sub PasteMacro()
Dim answ As Variant
    On Error Resume Next
    Set answ = Application.InputBox(Prompt:="Please select a destination Cell where you want to paste", Type:=8)
    On Error GoTo 0
    If Not answ Is Nothing Then
        Selection.Copy
        answ.PasteSpecial Paste:=xlPasteValues
    End If
    Application.CutCopyMode = xlCut
End Sub

Obtained from the OzGrid Help Forum.

Solution provided by Carim.