Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have some involved T and Pi filters I am designing. The Complex set of
functions work fine on the worksheet. However they can't be used in a VBA Function/Subroutine. The "Application.WorksheetFunction." inquiry brings up a list of functions, but does not list any of the complex functions. Is there some way to get VBA access to these functions? David Heiser |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If they are analysis toolpak functions, seta reference to the toolpak in
VBA, and call them directly. -- HTH Bob Phillips (remove xxx from email address if mailing direct) "David A. Heiser" wrote in message ... I have some involved T and Pi filters I am designing. The Complex set of functions work fine on the worksheet. However they can't be used in a VBA Function/Subroutine. The "Application.WorksheetFunction." inquiry brings up a list of functions, but does not list any of the complex functions. Is there some way to get VBA access to these functions? David Heiser |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
complex color fill conditions- if statements or complex formula? | Excel Discussion (Misc queries) | |||
Complex Index Match Help (or at least complex to me) | Excel Discussion (Misc queries) | |||
Need help programming some variable ranges | Excel Programming | |||
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? | Excel Worksheet Functions | |||
Complex programming task | Excel Programming |