Instant Excel Instant Excel

Go forth and index(match) !

Weh
Text to Clipboard with Office 365 / 64-bit

Text to Clipboard with Office 365 / 64-bit

Depending on which version of Excel you're using, you may find you're no long able to dump out text into the clipboard in VBA like you used to. I found an interesting bit of Win 10 /64-bit safe code on Stack Overflow -Original Stack Overflow Post. I'm presenting here in...
Read more
Colour by code in Excel with VBA - Part 3

Colour by code in Excel with VBA - Part 3

Following on from the previous entries  ( * see page list )  , in this post, we'll be looking at a few more methods to colour ranges / cells to achieve easy visual categorisation. Here's a few quick scripts / examples that you can use in your own projects. These...
Read more
Get fast in Excel! Shortcuts to speed up your workflow.

Get fast in Excel! Shortcuts to speed up your workflow.

Have you ever been frustrated scrolling through a huge spreadsheet, or filling out blocks of data a cell at a time?   Read on, as below are a number of shortcuts that'll save you time and energy in your daily chores!   CTRL + Spacebar   / SHIFT + Spacebar   Tired of clicking...
Read more
SQL connections and data import into Excel

SQL connections and data import into Excel

You might have some sophisticated BI tools like OBIEE  / QlikSense /  Power BI etc. , however sometimes it's useful to be able to prototype, or access tables / stored procedures etc directly through Excel. This can be slow and cumbersome working through Excel's query editor, especially if you're already...
Read more
Cleaner Code Part 1

Cleaner Code Part 1

When revisiting old functions, you'll often find some truly brute force methods used, usually due to time restrictions and trying to push together a solution as quick as you can. Something I recently came across was a quick UDF ( User defined function )  to return an integer month from...
Read more