Hi,
I have an input box that asks user to select a range of cells, then copies the cells and opens a new sheet.
I want to make sure if the user clicks on Cancel it exits the sub and if user clicks ok and the box is empty it prompts the user with a msgbox and else it continues with the macro...