I am writing a function that converts a compass bearing into mathematical degrees.
However, when applied on an empty cell, it takes the value as 0, so i'm trying to eliminate that.
The bold part is the erroneous part (the part that says
Please Login or Register to view this content., works fine without it.Please Login or Register to view this content.
If anyone can help out a newbie, it'd be greatly appreciated.
Thanks in advance. =)
Last edited by timothy.siu; 12-14-2010 at 08:47 AM.
dblBearing As Double
Source Excel VB help:
Double Data Type
Double (double-precision floating-point) variables are stored as IEEE 64-bit (8-byte) floating-point numbers ranging in value from -1.79769313486231E308 to -4.94065645841247E-324 for negative values and from 4.94065645841247E-324 to 1.79769313486232E308 for positive values. The type-declaration character for Double is the number sign (#).
So this variable does not accept value "" but takes zero.
Something like
Please Login or Register to view this content.
Last edited by royUK; 12-14-2010 at 08:52 AM.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Try this approach.
As B2A returns a double, I've arbitrarily set the return value to -1 if it is an error.
Please Login or Register to view this content.
Regards
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks