taking a range of an array

[jakeb3482]

ok so i need to calculate the average of a range in an array. i cant figure this one out.

i know to use worksheetfunction.average... but then i dont know how to call the range of the array...

help would be greatly appreciated. this is the last step in my code that i have been working on for about a week now.

thanks,
jake

 

[rjp]

I'm not sure I understand.

Are you saying that you've loaded a range of values from the worksheet into a VBA array and you want to get the average of the values in the VBA array?

 

[onlyadrafter]

Hello,

What is the range you are trying to average?

why not post the code as well.