Runtime error 1004 with use of WorksheetFunction

[Johny027]

Hello guys,

Few hours ago, I wrote a simple procedure in order to get an average of a range of 10 cells (A1:A10). Within the code, I typed these following lines:

Please Login or Register  to view this content.

Unfortunately, I get the following error message each time I execute the procedure:

“Runtime error 1004 : Unable to get the Average property of the WorksheetFunction class”

I have no idea how to figure out what is the solution to this error. I would greatly appreciate if you guys could take a look at this code.

Have a nice one,
Johny

[stanleydgromjr]

Johny027,

Try:

Please Login or Register  to view this content.

[Johny027]

Thank you stanleydgromjr for your taking the time to write this short message.

Unfortunately, I could still discover the same window after executing the procedure:

“Runtime error 1004 : Unable to get the Average property of the WorksheetFunction class”

I really don't know what is wrong with my code.

Have a nice day,
Johny

[DonkeyOte]

Johnny, posting partial code is rarely helpful...

You have myrange declared as a Variant rather than as a Range - any particular reason for that ?

Further, how is myrange populated ?

Can you conduct the same average natively without error ?

You would get the 1004 error should either of the below hold true:

a) underlying values contain errors (eg #VALUE!, #N/A, #DIV/0! etc...)

b) no numerical values to average

[Johny027]

Thanks for your suggestion DonkeyOte,

You forced me to examine again the purpose of this Runtime Error. Myrange was populated with 10 similar numbers as 77,55 or 78,45 …etc.

I am sorry for previously posting such a question. I simply worked with uncommon data (decimal points being replaced by commas)

Have nice one,
Johny.