Worksheetfunction does not function with object

[Manuel10]

Hello,

It seems to me that Worksheetsfunctions don't function at all when applied to an other excel object.
For example, while

Excel_Object.Workbooks(Bestandsnaam).Worksheets("Blad1").Range("J2:J10").Address

works properly, the next code

Application.WorksheetFunction.SumIf(Excel_Object.Workbooks(Bestandsnaam).Worksheets("Blad1").Range("J2:J10"), "<0")

simply does not work.
Can anyone confirm this, or am I doing something wrong here. (I actually hope the latter.) Thanks in advance.
Manuel Buys.

 

[SkipVought]

Hi,

Please post the code where you are using these statement fragments.

Skip,

_{[red]Be advised:[/red] Researchers have found another Descartes trueism, "Cogito ergo spud."
"I think; therefore, I YAM!}

 

[PHV]

Replace this:
Application.WorksheetFunction
By this:
Excel_Object.WorksheetFunction

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Manuel10]

Hello Skip and PH,

The problem is resolved.
Kips, thanks for your offer to help.
PH, your suggestion was the solution to the problems. A very logical suggestion.

Thanks a lot!
Manuel.