Complex Function in Excel 2007 VBA

A

Adam

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.
 
R

RB Smissaert

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
 
R

RB Smissaert

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top