Blogs from Wise Owl on Functions / arguments in VBA macros

Writing functions for Excel using VBA

Posted by Andy Brown on 24 February 2012

On-line training in writing functions using VBA, for use either within other VBA programs or within Excel itself.

Passing arguments to subroutines in VBA

Posted by Andy Brown on 09 February 2012

To become an efficient programmer, you need to stop writing one long subroutine and start writing lots of small ones instead - and to do this, you're going to need to know everything there is to know about passing arguments.