View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Palpha32 Palpha32 is offline
external usenet poster
 
Posts: 14
Default Custom functions

One of my custom functions calculates certain values("a" and "b") and then
calculates a result relying on "a" and "b". Am I able to use "a" and "b" in
another function by getting their value from the first function?

function one(x,y,z)
a = x + y
b = x + z
c = a * b
end function

function two(x,y,z)
a = x + y
b = x + z
d = a / b
end function

Thanks
Peter