Apache OpenOffice Community Forum

I have been working on a form for data review and input that uses a big macro. Recently, somehow I lost all macros. I went to my backups and found a database with the macros. However the main macro was out of date but I had a text copy of the latest version (attached). I copied the text and pasted it into the Sub. This macro worked before the problem and now gives this exception: Basic syntax error. "Function not allowed within a procedure." I can't get rid of the error. I feel it has something to do with how I pasted the text file. Any suggestions?

I'm guessing you have a Sub declaration that is not paired with an End Sub.