Hi Excel Monkey,

Sorry Norman. My data is in an VBA array. I want to extract the
Average of Column 1 within that VBA Array. I think your answer
assumed the data was in a range in the spreadsheet.

Your assumption is correct and , therefore, se my follow up post.

---
Regards,
Norman