-
VBA function with 3 arguments in 3 cells to the left of entered cell
I want to make a VBA function that will return a value in decimal degrees, using the degree, minutes and seconds values in the three cells to the left of any cell in which I choose enter the function. Essentially. it will perform the calculation
Decimal degrees = degrees + minutes/60 + seconds/ 3600
As for example here:
D |
M |
S |
Decimal degrees |
3 |
33 |
56 |
3.56555556 |
I have made a number of relevant searches, but the answers seem considerably more complicated than I would have expected. Surely there must be a simple VBA method to retrieve the values one, two, and three spaces to the left of the cell in which the function is entered?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules