Search

Welcome to Thought Asylum a place for me to share my thoughts, ideas and experiences with the rest of the world.  I try to post reasonably regularly and if you like the content consider subscribing to the site feeds.  If you're trying to find something specific try the search, otherwise just have a browse.


Entries in VBA (2)

Sunday
Apr302017

Batch Generating Worksheet Hyperlinks in Excel

In my work I often find myself building spreadsheets to carry out calculations, manage sophisticated processes and capture information. These spreadsheets can often extend to covering many worksheets and as a result it can be awkwardly slow to navigate to particular worksheets just by paging back and forth with the navigation buttons.

In this post I'm going to illustrate a couple of useful techniques to help you navigate around.

Click to read more ...

Wednesday
Dec282011

24 Hour Clock Calculations in Excel

Recently I've been doing some work with Excel to carry out some time calculations based on the results of an automated job. The job is sometimes triggered one night and finishes in the early hours of the next morning. After loading the figures into Excel I discovered that time calculations aren't always as simple as subtraction when times cross midnight. A quick test later and I had a workable solution that I thought might be useful to share.

Click to read more ...