I would like to choose a Range from Excel worksheet and then be able to msgbox the result in a string like this:
To include the name of the workbook file as well.
The Code goes like below but I need to modify it because I get errors.
Dim myRange As Range
Set myRange = Application.InputBox("LIST 1:" & vbCrLf & "Select Range", Type:=8)