Simple Input Box question

[Sforster]

I am sure you can do this, in fact I have done it before... But its monday morning and the brain is not working...

How do you configure the input box so that the user can drag over cells and the range is returned within the input box.

I am sure that you just set one of the input boxes arguments to 7 but can't quite remember

Can anyone boost my monday morning blues

Cheers
Steve

[Sforster]

O.k., Brain is starting to function...

Forgot to put application in front and its 8 not 7 i.e.

Myrange = application.inputbox("Message","Title",Type:=8)

Just in case anyone else has the same probs

Steve