Hello,

I want to make a userform under excel 2000 which does the following :

1) Allow the user to select a range of cells

2) Click a button to compute :

for j=1 to 5
s(j)=0
for i = 1 to number of selected cells
s(j)=s(j)+ cell(i)^j
next i
next j


The 1) I have done with a RefEdit element and during execution,
I have something like RefEdit1.Value="Sheet1!$A$2:$A$17"

My problem now is to une that value to compute the sums s(j)

Any ideas ?

Thankyou in advance

RR