View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
W Wolfe[_3_] W Wolfe[_3_] is offline
external usenet poster
 
Posts: 3
Default Function is Excel 2007

I have some spreadsheets with custon functions. They are stored in a module
when looking at the VBA window. These functions worked in 2003, but don't
seem to be recognized when I open the spreadsheet in 2007.

Here is one function:

Function GreatCircle(Satlong, ESlatN, ESlongE)
Convert = 180 / Application.Pi
GreatCircle = Convert * Application.Acos(Cos(ESlatN / Convert) *
Cos((ESlongE - Satlong) / Convert))

End Function

What should I be looking for?