Reply to thread

Message: [QUOTE="Joel, post: 6414213"] Cos and Cosh will except any real number positive or negative as well as zero. Adn VBa doesn't have an imaginary nor complex variable type. Threfore, the problem must be that the value is nothing. In VBA if you don't write to a location in an array or variable the initial value is NOTHING which will genrate the error you are getting. try adding the following to your code Dim Zl(100) as single 'or the size you need make surew you include a type like 'single, double Erase Zl 'sets array to zero [/QUOTE]