I am pretty new to VBA and am having a problem that is driving me crazy with a public function that I
tried to create.
I have a spreadsheet that has several custom public functions (some created by me, some created
by other authors). The problem that I am having is that one of the public functions is not showing up when I start to type it
in the spreadsheet (i.e., it is not showing up like =sum, or =product are). All the other functions that were created are
showing up fine.
The other weird thing about this though, is that I also made another function that references
the "missing" function in the VBA. This new function works fine, and seems to be using the "missing"
function fine as well.
Is there something that I am missing? I feel like there must be a simple solution to this
problem. Below is the code for the "missing" function.
StrtWeir(Length As Double, flow As Double) As Double
StrtWeir = ((flow) / (2.152 * Length)) ^ (2 / 3)
Thanks for any help and let me know if you need anymore information.