I'm getting stuck with this issues and need you all help:

I'm intending to write a sub, in which the code will ask user to chose some sheet, or range or ... anything in the work sheet. And it wait your user input before running.

InputBox does not support Range, sheets. And it even not allow us to select anything.

Is there anyway to do that??

Please help!!!