Suppose you wanted a function that returned the value in A1 doubled. There
are two ways to code this:

function bump(r as range)
bump=(r.value)*2
end function

and

function bump()
bump=(range("A1").value)*2
end function

put 10 in A1 and either code will return 20. However if you change A1 only
the first code will respond to the change.
--
Gary''s Student


"tzcarmy" wrote:


Thanx
I'll read it.


--
tzcarmy
------------------------------------------------------------------------
tzcarmy's Profile: http://www.excelforum.com/member.php...fo&userid=9232
View this thread: http://www.excelforum.com/showthread...hreadid=528022