I have an excel spreadsheet has the auto filter turned on. After I
filter the data for a specific user, I would like to get an average of
a column of just those filter results. Is there an easy way to do this
in my VBA code? I am using the average in my code for further
calculations so I dont want to use the =SUBTOTAL function to display it
on the worksheet.

Any ideas?

Thanks