View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spencer Hutton Spencer Hutton is offline
external usenet poster
 
Posts: 45
Default Custom functions using arguments with same name

I have written some functions in VBA to calculate profit margin, cost and
suggested retail price. they are simple in that the RETAILPRICE function has
two arguments, COST and MARGIN. i am also using an argument named COST in
the PROFITMARGIN function. how can i get VBA to recognize these as seperate
variables? do i have to put them in separate modules? or is there a certain
way i need to declare the variables? thank you.