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

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
-----Original Message-----
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
.

Range(RefEdit1).Cells.Count

--

Vasant

wrote in message
...
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
-----Original Message-----
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
.

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

--

Vasant

wrote in message
...
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
-----Original Message-----
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
.



.

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

"monika" wrote in message
...
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

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
--
Patrick Molloy
Microsoft Excel MVP

"Robin Hammond" wrote in message
...
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

"monika" wrote in message
...
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