I am not a fan of the merged cell format. It causes more problems that it solves. One issue you will face is trying to select a single column range within a range that has a merged cell. Here is how you handle it. This post is a video post as it easier to show the problem and the solution in a video. https://vimeo.com/739153569 This post is a video post as it easier to show the problem and the solution…
I am not a fan of Merged Cells but there may be a case to use them when creating a larger Sparkline chart.
(more…)In this short video I demonstrate how to create range names quickly based on labels. Range names are a powerful formula feature. I also demonstrate their use. https://vimeo.com/739173957
Using colours on your sheets can help you navigate and organise your file. If you want to sort your sheets by colour you can use a macro to speed up the process.
(more…)
When working with files in VBA code, you may need to know if a file is already open. A function can return TRUE if a file is currently open and FALSE if it isn’t.
(more…)
If you need to find the movement from the previous month a PivotTable can be your friend and do most of the work for you.