InputBox selects active cell, not selected cells?

I am trying simply to select a range with Application.InputBox method. It does ask to select the range and correctly specify it in a pop up window, but in reality it selects only the active cell (see two attached screen shorts, MsgBox shows number of selected counts). What is wrong?

I work with Excel 2007 on WinXP.

Thank you very much in advance!

The code is :

Please Login or Register  to view this content.

Welcome to the Board, however, please note:

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here


On this occasion I have added them for you - please endeavour to do so yourself from this point forth.

In your code you have not selected UserRange thus:

Please Login or Register  to view this content.

is applied to the active cell selection as opposed to the range specified via the InputBox dialog, to show that you would use:

Please Login or Register  to view this content.