This Excel add-in links the minimum, maximum, major, and minor values of a chart axis to worksheet cells.
For more see http://www.tushar-mehta.com/excel/software/autochart/index.html
Archive of entries posted on April 2010
Display a message for a specific duration
There are a number of instances where one may want to show a message for a specific duration. In other instances it might be for a specific duration or until the user acknowledges the message, whichever comes first. In the first category would be something like a splash screen or a very brief [...]
ByRef Arguments and the Application.Run Method
The Application.Run method is a versatile mechanism to call a subroutine particularly in another workbook or add-in. Its one documented limitation, if we want to call it that, is that all arguments are passed by value (ByVal). So, how does one pass an argument by reference (ByRef)?
For a version in a page by [...]