Find last used row or column
There are different ways to find last row or column which is populated.
Convert Column Number to Letter Or Letter To Number
Easy way to convert column letter to a number and column number to a letter.
Check if value exists in range
Code to find a value within range without looping
Hot cross bun martini
Inspired by Easter bake flavours.
Tikka roast chicken and chips
Chicken and chips is a favourite for a reason and this takes it to the next level with a spicy…
Turn on/off automatic formula calculation
Useful trick to stop Excel from calculating formula when not needed.