Hi,
I'll start by saying I'm new to VBA. I'm wondering how I can make a "public equation", similar to a Public variable? So I have a couple of Public variables, call them "Growth" and "Rate". How could I get the equation,
Rate = Application.Exp(Growth/2)
To be available throughout all functions, macro, etc?
Any help is always appreciated.
Thanks,
Hunter
I'll start by saying I'm new to VBA. I'm wondering how I can make a "public equation", similar to a Public variable? So I have a couple of Public variables, call them "Growth" and "Rate". How could I get the equation,
Rate = Application.Exp(Growth/2)
To be available throughout all functions, macro, etc?
Any help is always appreciated.
Thanks,
Hunter