Does anybody know of a function / add-in / piece of programming that will
generate the sunrise and sunset times for a location based on it's latitude
and longitude and the date.

I know there are tables on the intenet - but I would like to generate the
data within my worksheet - rather than copy data from the internet and spend
ages formatting it.

Worth a try!

All the best.