Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Never mind, I got it:
Sub servient() Dim r As Range Set r = Application.InputBox(Prompt:="Select range", Type:=8) ThisWorkbook.Names.Add Name:="MyNameRange", _ RefersTo:=r, Visible:=True End Sub Phil Smith wrote: Still no joy. Runs without errors, but MyRangeName is not being updated to reflect the choice... Gary''s Student wrote: Sub servient() Dim r As Range Set r = Application.InputBox(Prompt:="Select range", Type:=8) Set MyRangeName = r MyRangeName.Select End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Get user selected range into RefEdit | Excel Programming | |||
Referring to a user-selected range | Excel Programming | |||
Identify User Selected Range | Excel Programming | |||
Identify Range Selected By User | Excel Programming | |||
Determining end of user-selected range | Excel Programming |