Excel VBA

How to Remove PageBreaks in Excel with VBA

This post came about as a client of mine introduced a document classification product called Titus that works as an add-on to Microsoft Excel.  The Titus classification add-on caused an unexpected consequence, when you set the security classification of the…
Read more

Switch Alerts off with Excel VBA

A common problem achieving full VBA and Macro automation with Excel is that the warning messages can halt your script in the middle of processing.  Learn how to stop that problem and achieve full Excel automation with VBA… The problem…
Read more