Hi Dennis,
User functions don't always update like the built in functions. You may
have to force a calculation after making a change to the function.
tc
Dennis Marks wrote:
Thank you. I'll have to play with it. I tried a modification and I had
problems.
Function testit (theyear as integer, themonth as integer, theday as integer,
theweek as integer) as date
testit = date(theyear,themonth,theday)
end function
First I ran it without "theweek as integer" and a date was returned.
I added "theweek as integer" on the function line and got errors.
I went back and tried to change the date and it still returned the original
date.
I tried to use a named cell for theyear and got errors.
I think I have a lot to learn.
"Anthony Chilco" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
Hi Dennis,
Yes, you write them as basic functions in the macro editor. I've
attached a spreadsheet with an example. I'm cc'ing your address in case
the file is stripped in the list.
tc
Dennis Marks wrote:
Is there a way to create my own functions in Calc? There are some date and
time functions that I would like to create.
--------------------------------------------------------------------------------
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
