In vs direct call WorksheetFunction. Sum () error, in the great spirit show how vs implementation cell area summation of excel?

CodePudding user response:

What's wrong? Can the normal call ah,

 Public Class Form1 

Private Sub Button1_Click (ByVal sender As System. Object, ByVal e the As System. EventArgs) Handles for. Click 
Dim xlApp As Excel. Application=GetObject (, "Excel. Application") 
The Debug. Print (xlApp. WorksheetFunction. Sum (1, 2, 3)) 
End Sub 

End the Class 

CodePudding user response:

CodePudding user response:

refer to the original poster qq_22748985 response:

direct call in vs WorksheetFunction. The Sum () error, in the great spirit show how vs implementation cell area summation of excel?

CodePudding user response:

Not necessarily WorksheetFunction. Sum () error,
You use fast monitoring have a look at what each value is a part of the operation,

And use the Ribbon is high Office version, you reference version of the match not,