Greg![]() Legend ![]() ![]() ![]() ![]() Posts: 337 Joined: 3/22/2006 Location: Mishawaka, IN 46544 ![]() | Tom, I got this message on compile any thoughts? I assume it compiled for you... C:\Program Files (x86)\Nirvana\OT2020\VBA\Temp\TrendFlex.txt(111) : error BC30068: Expression is a value and therefore cannot be the target of an assignment. Trendflex(Bar) = (Summ(Bar) / SquareRoot(MS)(Bar)) ~~~~~~~~~~~~~~ C:\Program Files (x86)\Nirvana\OT2020\VBA\Temp\TrendFlex.txt(113) : error BC30311: Value of type '1-dimensional array of Single' cannot be converted to 'Single'. Call _Plot(Bar, "Trendflex", Trendflex(Bar)) ~~~~~~~~~~~~~~ Compiler return value: 1 Build failed. |