Thread: XIRR in VB
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default XIRR in VB
On Fri, 9 Dec 2005 12:25:48 +0200, "Nuraq" wrote:

How can I use the XIRR function provided in the Analysis Toolpak in VB?


Set a reference to atpvbaen.xls. Then you can use the XIRR function like any
VBA function.


--ron
Reply With QuoteReply With Quote