Error 1004: 'Unable to get the Atan2 property of the WorksheetFunction class'

  • Thread starter Thomas Lindberg
  • Start date
T

Thomas Lindberg

The Subject says it.

Help points to Tools-Macro-Security: it _IS_ set to 'Trust access to VB
project'
Err-ing codline:

Var3 = Application.WorksheetFunction.Atan2(Var2, Var1)

The code line is completed (an capitalized) by Exels VBA

What the he .. is wrong?

The code has worked in another setup!

Help appreciated!

TIA

Thomas
 

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

Similar Threads

runtime error '1004':Unable to get match property of worksheetfunc 1
Run-time error 1004: Unable to set the left property of the OLEObject class 0
1004 Error: Unable to set the LineStyle property of the Border class 1
unable to get match property of WorksheetFunction class 3
unable to set the locked property of the range class 8
"Unable to set the LineStyle property of the border class" 4
Hidden Property 1004 Error, Union of Rows 9
unable to get the pivotfields property of the pivottable class 1

Top