Select range via Inputbox

**nakul2617** · 02-20-2013, 03:04 AM

Hi,
I would like to select the range which i've entered in the inputbox.
Please let me know how to do that.

Thanks

**:) Sixthsense :)** · 02-20-2013, 03:16 AM

Try this...

Please Login or Register  to view this content.

**nakul2617** · 02-21-2013, 01:33 AM

Set rMyArea = Application.InputBox("Select Range", "Range Input Required", "A1", , , , , 8)
This is not working....I want to select the range on the worksheet which i have given in the inputbox....Please give full coding.
Thanks

**:) Sixthsense :)** · 02-21-2013, 01:55 AM

Try this...

Please Login or Register  to view this content.

**HaHoBe** · 02-21-2013, 03:37 AM

Hi, Sixthsense,

please press Cancel when running your code - RTE guaranteed.

@nakul2617
Could you please be a bit more precise than

This is not working

Code does not get started (must be invoked manually)? Range not selected? Sheet protected? RunTime Error? Which number?

Please Login or Register  to view this content.

Ciao,
Holger

**:) Sixthsense :)** · 02-21-2013, 03:51 AM

@ HaHoBe,

Good catch

But I just wanted to give an idea to OP about how to do it and not thought about avoiding the RTE since when the OP don't have time to explain his requirement in brief