| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Error when using Yield in Excel 2007 VBA
Application.WorksheetFunctions.Yield(7 pars) returns error: "Object does not
support method", when called from VBA code. It works fine in the cell (=YIELD(...) ). All others functions used (Price, Duration, MDudation) works fine from VBA. I'm using Office-Pro-2007 60 days Trial, with SP1 included, Activated; to update a 2000 and 2003 project for Office 2007 use. Is this a bug? Is beacuse of Trial version? Some SP missing? Thanks for any help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Yield fomula error #Name? | Excel Discussion (Misc queries) | |||
| How do I compute effective yield in Excel when there is a balloon | Excel Worksheet Functions | |||
| Excel slow due to Yield and Duration Functions | Excel Discussion (Misc queries) | |||
| how do you calculate "dividend yield using Excel? | Excel Discussion (Misc queries) | |||
| Download dividend yield to excel | Excel Worksheet Functions | |||
Threaded Mode
