Type:= 8 means user can select a range, just as you want.

RBS


"Jody L. Whitlock" <[email protected]> wrote in message
news:[email protected]...
> Nick Hebb wrote:
>
>> Try using an InputBox() function with Type:= 8
>
> InputBox?? Make the user type the cellrange in? I was kinda hoping to
> allow the user to use the mouse, select his/her cells, and detect
> these...