View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default sub or fuction not defined

Hi Steven,

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


---
Regards,
Norman



"Steven" wrote in message
.com...
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?