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
.