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