Stack Overflow for Teams is a private, secure spot for you and your coworkers to find and share information. Learn more. VBA: Passing a Function as an Argument. Ask Question Asked 4 years, 10 months ago. Active 2 years, 1 month ago. Viewed 4k times 1. I'm trying to pass a function (2 functions, actually) as arguments for a Sub with the line: Call OpenPulledReports(GetFilePaths(), GetFileNames.