Recent content by Lucas

Thank you for the reply! Unfortunately the NewCalculateUTMNorthing function is still producing the same VALUE error message. I'm using Microsoft Excel 2016 (16.0.5422.1000) MSO (16.0.5422.1000) 32-bit. Is this version too outdated to run this successfully? The Easting and Zone functions work...

Hi, I'm following the guide posted by LUTFOR RAHMAN SHIMANTO (https://www.exceldemy.com/convert-lat-long-to-utm-excel/) to convert between latitude/longitude and UTMs. Everything works except for the CalculateUTMNorthing function, which returns a VALUE error. Any tips on where I went wrong...