Selecting Refedit value

[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

 

[Guest]

I jsut resolved this problem. I can get diff cell values
through Range(RefEdit1).Cells(1).Value, Range
(RefEdit1).Cells(2).Value....

but if anyone can still suggest me as to hwo to know how
many cells i have selected..it would be gr8 help
thanks

 

[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

 

[Vasant Nanavati]

Range(RefEdit1).Cells.Count

--

Vasant

I jsut resolved this problem. I can get diff cell values
through Range(RefEdit1).Cells(1).Value, Range
(RefEdit1).Cells(2).Value....

but if anyone can still suggest me as to hwo to know how
many cells i have selected..it would be gr8 help
thanks

 

[Guest]

cool thanks

-----Original Message-----
Range(RefEdit1).Cells.Count

--

Vasant




.

 

[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