InputBox Method
Displays a dialog box for user input. Returns the information entered in the dialog box.
See InputBox Method
Intersect Method
Returns a Range object that represents the rectangular intersection of two or more ranges.
See Intersect Method