access a public function and enter the number in a macro

  • Thread starter Thread starter BillRobPV
  • Start date Start date
B

BillRobPV

I have a public function called maxdays, with only the line maxdays=400 (or
some number). I have several macros that call maxdays, and should use that
number in subsequent calculations. They access and run the function OK, but
they do not return the number and use it. Please tell me the code I should
use in the macros to get that number. TIA
 
You could assign that function to a variable, like:

my_variable = maxdays()

then use the variable in your macro.

Hope this helps.

Pete
 
Pete, thank you very much. With some fiddling, I got it to work. I am new to
this site, and I can't seem to find the .net access (in communities) for
rating the post. So if I don't rate it, it is not because it wasn't helpful.
Thanks again.
 
You're welcome, Bill - thanks for the feedback.

The rating system seems to vary depending on how you access the
newsgroups - in Google Groups (which I use) it is star system.

Pete
 
Back
Top