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 [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2010/04/05/byref-arguments-and-the-applicationrun-method/
Posted
Apr 05 2010, 11:37 PM
by
Daily Dose of Excel