Selecting Refedit value

M

monika

Hi.

I am using refedits and am selecting a range of
cells...i.e. more than one cells. If I select a single
cell then I can get the refedit value from the Range
(Reedit1) or Range(RefEdit1).Cells(1).Value or
RefEdit1.Value. I got this help from this user group
itself. Now my criteria is changed and now i want to
select values say for e.g. from $BO$304:$BQ$304. How can I
extract the values into a variable???? Can it be done.

thanks a lot
Monika
 
R

Robin Hammond

Monika,

You can set a range or refer to a range according to the refedit value

e.g.
Dim rngInput as Range
set rngInput = Range(Refedit1.Value)

then rngInput.count, rngInput.address, rngInput.cells(1,1).value should all
work.

Robin Hammond
www.enhanceddatasystems.com
 
P

Patrick Molloy

Once you have the range you can get the data from the range as per any
other range...
Dim mydata as Variant
mydata = rngInput

Now you can use the UBound and LBound functions
 
Top