Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Function in Excel 2007 VBA
I have a macro that I have used previously in Excel 2003. In that macro, I
use the function complex(). When I go to run the macro in Excel 2007, it gives me an error and wants worksheetfunction.complex() instead of just complex(). Is there a way to fix this? I don't want to have to have to go through all my macros and change the function name. It is also doing the same thing for improduct() or any other complex funtions. Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Function in Excel 2007 VBA
How about:
Replace all complex() in your project with complexNew() with the Find and replace facility. Then make a function like this: Function complexNew() complexNew = Application.WorksheetFunction.Complex() End Function RBS "Adam" wrote in message ... I have a macro that I have used previously in Excel 2003. In that macro, I use the function complex(). When I go to run the macro in Excel 2007, it gives me an error and wants worksheetfunction.complex() instead of just complex(). Is there a way to fix this? I don't want to have to have to go through all my macros and change the function name. It is also doing the same thing for improduct() or any other complex funtions. Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Complex Function in Excel 2007 VBA
Actually, you might as well replace all complex() with
application.worksheetfunction.complex() with the Find and Replace. Search whole word and case-sensitive. Always backup before doing this. RBS "RB Smissaert" wrote in message ... How about: Replace all complex() in your project with complexNew() with the Find and replace facility. Then make a function like this: Function complexNew() complexNew = Application.WorksheetFunction.Complex() End Function RBS "Adam" wrote in message ... I have a macro that I have used previously in Excel 2003. In that macro, I use the function complex(). When I go to run the macro in Excel 2007, it gives me an error and wants worksheetfunction.complex() instead of just complex(). Is there a way to fix this? I don't want to have to have to go through all my macros and change the function name. It is also doing the same thing for improduct() or any other complex funtions. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
very complex IF function if not an alternative function of crossselection | Excel Worksheet Functions | |||
Excel 2007: complex COUNTIFS() | Excel Worksheet Functions | |||
complex function | Excel Programming | |||
Use Excel to make a complex IF function. | Excel Worksheet Functions | |||
complex excel formula Array how do I convert it to a vba Function | Excel Worksheet Functions |