| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using with...
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using with...
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Using with...
oops... thanks!
Doug Glancy wrote: It looks to me like you forgot to put your periods in front of the functions: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
