Selecting a range in Excel

[sKorno]

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

[JHausmann]

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

[sKorno]

This is within an Excel spreadsheet.

[damonous]

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?