Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am developing an application to calculate navigation data from Sun & Star
sights (interesting for sailors, boring for everyone else). The problem is that I appear to be getting small inaccuracies when calculating angles. I have used Double as the data type. Looking through the help files I note that there should be a 'Decimal' data type that uses many more digits so potentially improving accuracy. However, a line such as: Dim dLat as Decimal results in a message: 'Compile error: Expected: New or type name' I understand that this is saying it doesn't recognise the Decimal data type. Do I have to add a library to use this? if so which one? Any ideas gratefully received. Peter Morris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 error "some chart types cannot be combined with other chart types. Select a different chart types" | Charts and Charting in Excel | |||
Trig Function seems odd. | Excel Worksheet Functions | |||
Trig functions | Excel Worksheet Functions | |||
Data types when importing Excel data to SQLServer | Excel Discussion (Misc queries) | |||
how can I perform trig. functions usings grads 400deg per circle | Excel Worksheet Functions |