| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
select range and put range address in variable
Through a command button in a user form, I want to ask a user to select
a group of cells(range). The user selects the cells. I would like to retrieve the address of that range and place it in a variable. Mary |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select range and put range address in variable
Try the RefEdit Control. It should be one of the standard controls in you VBA
toolbox. It is used for selecting ranges... -- HTH... Jim Thomlinson " wrote: Through a command button in a user form, I want to ask a user to select a group of cells(range). The user selects the cells. I would like to retrieve the address of that range and place it in a variable. Mary |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select range and put range address in variable
Hi
Also this might help you sub Example () Dim task As Range Dim str As String Range("a1:c4").Select ' for example Set task = Selection str = task.Address MsgBox ("TASK= ") & str End Sub "Jim Thomlinson" wrote in message ... Try the RefEdit Control. It should be one of the standard controls in you VBA toolbox. It is used for selecting ranges... -- HTH... Jim Thomlinson " wrote: Through a command button in a user form, I want to ask a user to select a group of cells(range). The user selects the cells. I would like to retrieve the address of that range and place it in a variable. Mary |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a variable range | Excel Worksheet Functions | |||
| Range Address Memory Variable Limitation | Excel Programming | |||
| Select a Range Through a Variable | Excel Programming | |||
| How do you get a Selected Range address into a variable? | Excel Programming | |||
Hybrid Mode
