Excel VBA - Passing Argument Parameter to Sub
<p>I have a function that has an argument I'd like to pass to a sub's variable in Excel VBA.  The function's argument is a range, say A1:B1, so I'd like that range to be passed to another sub.  Is there a way to do this?  Everything I've read on the internet so far deals with passing the result of a function or arguments between subs, but not a function's argument passing to a sub's variable.</p>

<p>Thanks in advance!</p>

<p><strong>Edited for more detail:</strong></p>

<p>I have a function, BuildpgSQL, with the following arguments that are all range data types:  FieldNames, Table, PageFilters, and GroupBy.  I also have a sub that will use the same PageFilters range as a variable.  Rather than define the argument twice - once for the function and again for the sub, I'd like to pass just the PageFilters argument from BuildpgSQL to the sub's variable.</p>