ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Complex Variable Programming (https://www.excelbanter.com/excel-programming/361116-complex-variable-programming.html)

David A. Heiser[_2_]

Complex Variable 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



Bob Phillips[_14_]

Complex Variable 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






All times are GMT +1. The time now is 11:27 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com