Sleeper: Select range

[excelliot]

hi
im writing one macro
wher user provides range manually, but i observed that they makes mistake in specifying range

so any vba code wher user can select range by cursor as input & after that specify two different ranges say range a for one data output and say range b for other data output

thanks in advance

[BlueCactus]

If you're in a form you could use a RefEdit control.

[excelliot]

If you're in a form you could use a RefEdit control.

No im using just VBA macro wiyhout form.

[Bob Phillips]

No im using just VBA macro wiyhout form.

Then use an application inputbox with a type of 8

Dim rng as Range

    Set rng = Application.Inputbox("Select the target range with the mouse", Type:=8)

[alimcpill]

Yegads!!! If only I'd known 3 years ago about this 'type' parameter!!!

I've been writing excel vba for years but i've always just used Inputbox(...) and not Application.Inputbox(...), the first is a member of VBA.Interaction and doesn't let you specify type, so i've always had a hard time getting the user to specify a range. It never even occured to me that excel might offer its own inputbox so you can specify the return type!

Am I alone in this folly or has anyone made this mistake??

[sheeeng]

Then use an application inputbox with a type of 8

Dim rng as Range
 
Set rng = Application.Inputbox("Select the target range with the mouse", Type:=8)

How to use Type?

[Bob Phillips]

How to use Type?

In VBA, there is a useful function called Help

[sheeeng]

In VBA, there is a useful function called Help

Sorry, thanks.

I have a look to it later...