Programming with VBA allows spreadsheet manipulation that is awkward or impossible with standard spreadsheet techniques.Programmers may write code directly using the Visual Basic Editor (VBE), which includes a window for writing code, debugging code, and code module organization environment.
It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications.
”, and besides being an Excel Guru, I usually tell them about the great addins that I have found.” –Peter R., Logistics Engineer“Paste Buddy is one of those tools you wonder how you managed without.
I like how you can customise it to suit your needs and preferences, and it has certainly improved my efficiency.
Wouldn’t it be great to be able to link the axis scale parameters to values or, even better, formulas in the worksheet? If you want a ready-to-use solution, try Tushar Mehta’s Auto Chart Manager add-in, available as a free download at You can write the entire procedure yourself, but it’s easier and more reliable to let the VB Editor start it for you.
There are a few pieces you need to make this technique work. Click on the left hand dropdown at the top of this module, and select Private Sub Worksheet_Change(By Val Target As Range) With Active Sheet.