How can I execute an Excel function?

Is there a way to wrap calls to Excel built-in functions in VBA?

Answers


Yep, just prefix with WorksheetFunction.

eg WorksheetFunction.VLookup(...


Need Your Help

CorePlot-CocoaTouch.h file not found

iphone ios4 ios5

I'm developing an app in which a graph is drawn using coreplot. When I run the project on the system in which it is developed there is no problem. When I move it to other system and then take a bui...

Change width to a IBOutlet (UIImageView)

swift uiimageview iboutlet cgrect programmatically-created

I was doing some experiments with Xcode an a little question comes to my mind: that is how I could change size of an UIImage created by storyboard. below the code I used: