ExcelBanter - Using with...

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Using with... (https://www.excelbanter.com/excel-programming/294325-using.html)

May I use the statement "with" with Application.WorksheetFunction?

VBA for Exce doesn't like this part of code...
Other things go well...

With Application.WorksheetFunction
Test = Test + (Rng2(i) - Weibull(Rng1(i), ParA, ParB, TRUE)) ^ 2 / Weibull(Rng1(i), ParA,
ParB, TRUE)

Thanks, Alex.

It looks to me like you forgot to put your periods in front of the
functions:

Test = Test + (Rng2(i) - .Weibull(Rng1(i), ParA, ParB, TRUE)) ^ 2 /
..Weibull(Rng1(i), ParA,
ParB, TRUE)

hth,

Doug

"y" wrote in message ...
May I use the statement "with" with Application.WorksheetFunction?

VBA for Exce doesn't like this part of code...
Other things go well...

With Application.WorksheetFunction
Test = Test + (Rng2(i) - Weibull(Rng1(i), ParA, ParB, TRUE)) ^ 2
/ Weibull(Rng1(i), ParA,
ParB, TRUE)

Thanks, Alex.

oops... thanks!

Doug Glancy wrote:

It looks to me like you forgot to put your periods in front of the
functions: