I want the user to enter a row number - easy:

RowSou = InputBox("Enter source row")

But I also want the user to specify which sheet the row number is on. I
could have the user enter the sheet name manually in another input box, but
with the risk of typos or misspelling i'm looking for a nicer way for the
user to select the correct sheet. Please supply any code you may think could
do the trick.

Thank you.
The Doctor

Dim rng As Range

Set rng = Application.Inputbox("Select range",Type:=8)

In this the user selects the range,including the sheet, not type it. You
then work on the range object.

--
HTH

Bob Phillips

"Dr.Schwartz" wrote in message
...
I want the user to enter a row number - easy:

RowSou = InputBox("Enter source row")

But I also want the user to specify which sheet the row number is on. I
could have the user enter the sheet name manually in another input box,
but
with the risk of typos or misspelling i'm looking for a nicer way for the
user to select the correct sheet. Please supply any code you may think
could
do the trick.

Thank you.
The Doctor

Thanks Bob, just what I was looking for.

"Bob Phillips" wrote:

Dim rng As Range

Set rng = Application.Inputbox("Select range",Type:=8)

In this the user selects the range,including the sheet, not type it. You
then work on the range object.

--
HTH

Bob Phillips

"Dr.Schwartz" wrote in message
...
I want the user to enter a row number - easy:

RowSou = InputBox("Enter source row")

But I also want the user to specify which sheet the row number is on. I
could have the user enter the sheet name manually in another input box,
but
with the risk of typos or misspelling i'm looking for a nicer way for the
user to select the correct sheet. Please supply any code you may think
could
do the trick.

Thank you.
The Doctor