Selecting a range in Excel

Okay, I am working with an excel document and I have an input box coming up asking for a range, I have the string for selecting the range, but I need that put in to a variable, what kind of variable does it need to be? Nothing seems to work! Please help.

Thanks in advance

The easiest way to get the code you need is to turn macros on (in Excel), select the range, turn macros off and cut-n-paste the macro code into VB

This is within an Excel spreadsheet.

I'm sort of confused on what you want, but here is my attempt.

Dim sResp as string

sResp = input("Please enter a range.", "Enter Range")

Now the response is in string format.

Is that what you wanted?