Using Regular Expressions for sub strings in Excel

Ever wanted to extract a sub string from a cell in Microsoft Excel using a Regular expression? Here’s a Visual Basic snippet that will do just that. Function getRegexGroup(inRegex As String, inValue As String, inGroup As Integer) Set myRegExp = … Continue reading

Show only successors to a selected task in Microsoft Project

I’ve frequently wanted to quickly show all the tasks which are dependant on another from within Microsoft Project but have never found a quick was and easy way using stock the tools. The following is a snippet of Visual Basic … Continue reading

Showing parallel tasks in Microsoft Project

Whilst working in Microsoft Project, I often want to know what tasks are running in parallel to one another. I’ve never found how to do this using inbuilt functions so I wrote a Macro to do it for me. To … Continue reading