I am in need to have an application.inbox prompt a user to enable the user to click a particular cell. From there i need the address of the cell as well as the sheet.
Dim MyRange As Range
Set MyRange = Application.InputBox("Select the range to process", Type:=8)
If Not MyRange Is Nothing...