Hi
Have somebody use the Complex Numbers Functions like IMPRODUCT or IMDIV in VBA function?
Thanks in advance
Hi
Have somebody use the Complex Numbers Functions like IMPRODUCT or IMDIV in VBA function?
Thanks in advance
Sorry, something went wrong during posting the message.
The actual question is related to correct extracting the complex number from the function and placing it into a cell ready for another operation with excel complex functions.
Thanks
Last edited by Valex; 12-05-2005 at 12:40 PM. Reason: wrong message
To use those functions in VBA you would need to set a reference to atpvbaen.xls in the VBA editor under Tools>References...
I've never used these functions in Excel or VBA so I don't know what the synyax/code would be for what you want to do.
Thanks Norie
Having a cell name ww ="2+2j", the function is
Function GatFsw(ww)
GatFsw = WorksheetFunction.IMPRODUCT(ww, 2)
End Function
The function is called by GatFsw(ww) and terurns #VALUE!
On the other side cell =IMPRODUCT(ww,2) is returning correct result 4+4j
Valex
Try removing WorksheetFunction.
If you have your reference set right (VBE | Tools | References) then you just call them on their own, they are not part of the WorksheetFunction object.
Syntax is:
IMPRODUCT(number1, number2, number3...number 29)
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables