How to pause a macro

[Lino123]

Is there a syntax in vba (macro) to copy a formula from a certain cell, then pause the macro to alow me to select two or three cells to paste to, then restarts the macro to paste the copied cell to the selected cells.

 

[SunnyAlv]

like this ??

Sub CopyPaste()
On Error Resume Next

Title = "Copy Paste"
 Set Copy = Application.Selection
Set Copy = Application.InputBox("Chooce Cell/Range want to Copy, then click OK:", Title, Copy.Address, Type:=8)
    
 Set Paste = Application.Selection
Set Paste = Application.InputBox("Chooce Cell/Range want to Paste, then click OK:", Title, Paste.Address, Type:=8)
    
    Copy.Copy Paste

End Sub