vba macro code for calculating average of all the cols

[Dharani Suresh]

Dear Sir/ Madam,
In the given excel file, i need to calculate the average of all the columns and display with the name of average in the last row (where the data ends). For your easy understanding, i have worked out and attached the file for your kind reference.

please help and do the needful.

Thank you,

Regards,
Dharani.