Excel VBA Tips: Get Shape Properties Lately, I have been working with shapes in excel – moving, creating, making them invisible and resizing them. This seems easy, but because excel codes the location of an object from the top left of cell A1, it makes it very difficult to work out exactly where the object…
Read More
Excel VBA Tips: Closing All Non-Active Workbooks If you ever need to close off all the workbooks you have open in the background but don’t want to have to navigate to each one, this code is extremely useful. Public Sub CloseAllInactive() Dim Wb As Workbook Dim AWb As String AWb = ActiveWorkbook.Name ‘Your code here,…
Read More
Excel VBA Tips: Large concatenation OR concatenating multiple ranges One of the useful worksheet functions in excel is being able to concatenate cells into a single cell. However, if you try to concatenate a large number of cells or a multiple ranges, it can become very problematic. However, after searching today, I came across this…
Read More
Excel VBA Tips: Running macros using hyperlinks At work today I had to create a workbook that provided links between different sheets within a workbook and turned on a filter. However, I didn’t want to use buttons, as it would be become extremely cluttered. I discovered that you can run macros using hyperlinks, so commandbuttons…
Read More
SUBMEG 