sub or fuction not defined

S

Steven

Can anyone help me?
This line of code bring up the message when run "sub or function not
defined" and highlights the acos in the code.
Cells(i, 2) = Cos([L2] * Acos(Cells(i - 1, 2) / Radical))
I've tried alot- can you help me?
 
K

Ken Johnson

Steven,
Acos is an xl Worksheet function, not a VB math Method and should me
addressed as WorksheetFunction.Acos(Cells(i-1,2)/Radical ).
That might be the problem.
Ken Johnson
 
N

Norman Jones

Hi Steven,

ACOS is an Excel worksheet function, so try changing Acos to
Application.ACOS
 
D

Dave Peterson

VBA's help also shows this as a derived math function:

Inverse Cosine
Arccos(X) = Atn(-X / Sqr(-X * X + 1)) + 2 * Atn(1)
Can anyone help me?
This line of code bring up the message when run "sub or function not
defined" and highlights the acos in the code.
Cells(i, 2) = Cos([L2] * Acos(Cells(i - 1, 2) / Radical))
I've tried alot- can you help me?
Click to expand...
 

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

Application or object defined error 10
VBA Assigning cell value to variable giving runtime error 3
Improving Macro That Keeps First Letter 0
Need Help with a VBA subroutine 0
Need Help with Macro Security 1
How to call module function or sub from the Add In? 3
PlaySound error (Chip Pearson site) 2
Prompt For Replace in Selection And More... 0

Top