Trying to apply formula to each column and row in every sheet

thank you for that, With that fix the formula isn't doing what i would like it to do. I will admit i had to do some research online to attempt to write that line and it doesn't seem to be quite right. Any suggestions on how to write that line to get it to look at each worksheet as it flips through them and look at each row? I tried running it as the activeworksheets(I).range but that didn't work. Any tips much appreciated!

Thanks JLGWhiz that worked for the average function. I will see if i can replicate for other formulas i want to use. Thanks so much!

Hi JLG,
The code was working fine yesterday. Towards the end of the day and this morning it stopped working and I am now getting autofill method range of class failed run time error 1004. When I walk through the code it looks like the row_count and column_count functions are getting stuck at 7 and 2 respectively regardless of how many rows and columns there are in the worksheet. Any thoughts on what might of caused this to happen?

for a little more troubleshooting help, when I use my original code to count rows and columns that does give me the correct row and column count

Sorry for the spam updates,
It looks like it has something to do with being in my personal macros instead of in the macros on the worksheet i am working on. When i take the code and place it into the "thisworksheet" section it works fine. Ideally id like to have it in my personal macros so i can apply it to any excel i open or data i pull in from the API i am working with. Is there a way to make it capable of doing this?