M
moshe
the folowing function
function sumrange(r as range,c)
dim c as variant
for each c in r
if c>0 then
sumrange = c/worksheetfunction.sum(r)
sumrange= format(sumrange,"##,##.00")
next c
end function
is an attempt to calulate for each cell in a range ,the
ratio between the cell & the total value of the range.
my question- how can i program the function to create
absolute reference to the range i choose,without using the
f4 button.
thanks
function sumrange(r as range,c)
dim c as variant
for each c in r
if c>0 then
sumrange = c/worksheetfunction.sum(r)
sumrange= format(sumrange,"##,##.00")
next c
end function
is an attempt to calulate for each cell in a range ,the
ratio between the cell & the total value of the range.
my question- how can i program the function to create
absolute reference to the range i choose,without using the
f4 button.
thanks