This is the Excel category.

The Excel category is all things Excel. Functions, formulas and macros are all covered in this category. If it happens in Excel, you will find it in this category.


Excel iconVBA icon

TimezoneDb API returns time zone information

TimezoneDb has an API which returns time zone information about a geographical point (latitude/longitude).

It requires an API key, which you can sign up for using the above link. I have an API key but have removed it for this example. In this article we'll review how to access the API using VBA. I've created a function which can be used on the worksheet (as a UDF) and also in VBA.

Continue Reading »

Random Data Generator