I have an excel template with some third party functions. The function accepts an old code as an arguement and returns a new code. so:
=GETNEWCODE("21E") returns 800B which is the new code. There are only a finite number of old codes the function GETNEWCODE will recognize. I want to use VBA to find out what old codes GETNEWCODE will accept.
So is there anyway to "look inside" a custom excel functioin using VBA to pull out the acceptable arguements?