Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't find the YIELD method
HI
I am using Excel 2007. I can't find the YIELD method that once worked in Excel 2003 in VBA? I believe that it was part of ATP. Now its nowhere and the VBA code is now broken...help please! Thanks! Steve I accidentally posted in a nested thread earlier. Sorry for the re-post. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't find the YIELD method
I don't have 07 yet, but for 03 you have to have the Analysis Toolpak add-in
installed. Likely will be the same in 07. -- -John Northwest11 Please rate when your question is answered to help us and others know what is helpful. "sinclas" wrote: HI I am using Excel 2007. I can't find the YIELD method that once worked in Excel 2003 in VBA? I believe that it was part of ATP. Now its nowhere and the VBA code is now broken...help please! Thanks! Steve I accidentally posted in a nested thread earlier. Sorry for the re-post. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
I can't find the YIELD method
sinclas -
I don't think YIELD was ever a method. I think it was and is a worksheet function. Before Excel 2007, it requires that the Analysis ToolPak add-in is available. In Excel 2007, I think the functions previously in the Analysis ToolPak are now automatically a part of Excel (whether or not the Analysis ToolPak is loaded). Perhaps this affects the way you use the function in VBA. - Mike http://www.MikeMiddleton.com "sinclas" wrote in message ... HI I am using Excel 2007. I can't find the YIELD method that once worked in Excel 2003 in VBA? I believe that it was part of ATP. Now its nowhere and the VBA code is now broken...help please! Thanks! Steve I accidentally posted in a nested thread earlier. Sorry for the re-post. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Bond premium amortization using the constant yield method | Excel Worksheet Functions | |||
Current Yield vs. Yield to Maturity at low prices | Excel Worksheet Functions | |||
xls vba find method to find row that contains the current date | Excel Programming | |||
date find using find method | Excel Programming | |||
Using variables to make a date and using find method to find that. | Excel Programming |