Hello Gurus,

I am in need of the code to be able to do the following.

I am running a macro that copies a picture > opens another excel spread sheet > and pastes it to a user specified range. All works well as is.

Problem:

I cannot change the worksheet before specifying the range.

Is it possible to pause the macro using a msgbox "Select worksheet" > user select the worksheet > and hit "OK" button to resume? I would think I could place the code just before the set Rng command.

Sub tdk()
'
' tdk Macro
'

'
    Range("AI3:AN8").Select
    Range("AM5").Activate
    Selection.CopyPicture Appearance:=xlScreen, Format:=xlPicture
    Workbooks.Open Filename:= _
        "\\Vmfiles\users\TimlmiT\My Documents\Excel test\master RFQ\MASTER QUOTE LIST.xlsm"
    
    Set Rng = Application.InputBox(prompt:="select range to paste", Type:=8)
    Rng.Select
    ActiveSheet.Pictures.Paste.Select
    Range("B9").Select
End Sub
If so, please help, I am beyond my understanding of VBA.

TIA,
Tim