[mso] Re: Excel 2000 Personal.xls
- From: "Robert Carneal" <carnealre@xxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 20 Dec 2006 20:12:25 -0600
Linda and everyone-
Here is the formula I wrote; not perfect, but shouldn't it work?
Function Latify(Decimal_Deg) As Variant
With Application
Degrees = Int(Decimal_Deg) 'Get Integer of Argument
Port = Decimal_Deg - Degrees 'Get portion of Degrees
MinutesO = Port * 60 'Get Minutes value
Minutes = Int(MinutesO) 'Get Integer port Minutes
Port = MinutesO - Minutes 'Get dec port of Minutes
SecondsO = Port * 60 'Get Seconds value
' Finished calculating, do Formatting....
Seconds = Format(SecondsO, "00.0000") ' Format Seconds
Minutes = Format(Minutes, "00") ' Format Degrees
Degrees = Format(Degrees, "00") ' Format Minutes
'Put it all together...
Latify = Degrees & Minutes & Seconds
End With
End Function
I hope that is readable to everyone.
It *should* accept a decimal value, and convert it to a DDMMSS.xxxx value, I
think. If the Degree_Deg value is:
32.8193127 for example, Latify should be: 324909.5257
Ok,.. this was on Microsoft's site, but it had the degree, minute, and
second symbols, which for me was not useful. So I changed it. Nonetheless,
it seems as if should work in the main sheets. What do you guys think?
The question is how can I make it available via Personal.xls to other
workbooks, worksheets? This is the program that when I run, I get the #NAME?
Error, though I am pretty much at a loss as to why.
Thank you, everyone.
Robert
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of
Robert Carneal
Sent: 2006-12-20 18:09
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2000 Personal.xls
Linda- I am not referring to ranges, at least not intentionally. Just the
cell I reference to. I am away from my "Excel" computer, but when I get
home, I will copy it and post it. Maybe someone will get a chance to see an
obvious error; I think that is all it is. I am sure missing it.
Thank you.
Robert
-----Original Message-----
From: mso-bounce@xxxxxxxxxxxxx [mailto:mso-bounce@xxxxxxxxxxxxx]On Behalf Of
Linda F. Johnson
Sent: 2006-12-20 17:24
To: mso@xxxxxxxxxxxxx
Subject: [mso] Re: Excel 2000 Personal.xls
#NAME? means that Excel doesn't recognize the name of a range or a function
.... Is it possible the formula you are storing in personal.xls refers to a
range name that is not in personal.xls? If your formula refers to a range
name, then that name must exist either in the open workbook or in
personal.xls or you will get this error
Linda F. Johnson
Linda's Computer Stop
Author, MOS: Excel 2003 Study Guide, published by John Wiley and Sons
http://personal-computer-tutor.com
I have written a function that while I have Personal.xls open, it works in
that spreadsheet. When I close it, hide it; I thought it that function was
supposed to be available to *all* sheets? So far, that is not the case. When
I try to use the function in another sheet, I get #NAME? as result.
I checked the Microsoft Knowledge Base, and it suggested I change my
security level to "Low." That bothers me, as I sometimes have to open
unknown email for the company to do volunteer work for. Is there another way
to make a function available to every workbook I open, but still maintain
good security settings?
Thanks.
Robert
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the
dropdown menu at the top. This will allow you to unsubscribe your email
address or change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
