Calculate Average in VBA for specific cells

Hi,

I want to Average the values of some specific cells of the last row of my spreadsheet. Here is what I am trying to write, but I have no clue how to proceed further... (and its not working, obviously)

Can anyone provide me with a solution (or a better solution) to this. [Note that I have already defined my lastrow and the integer variables in the below code]

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks Andrew...

Your formula is working but in your case it will always divide the value by 6 even if my few cells are blank, which results in wrong average.

Is there any other way?

Please Login or Register  to view this content.