Find 0's down a column and replace the Average of adjacent cells

Try this:

Please Login or Register  to view this content.

Try this:

Replace the zeros with =Memo()

The Memo function will do the heavy work for you.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

xladept, Thank you very much.
Your code works but is working on cells with leading zeros. Many of the values in column H are below 1 decimal values with leading zero's, so it is returning some strange results. I need this to only work on cells that only have a single zero, and return values of like kind, single decimal place values.

Oops

Please Login or Register  to view this content.

You're welcome and thanks for the rep!

*I modified the code.