Hello,
I'm trying to write a simple vb script in excel which will find blank cell values in a specific row, and then calculate a new value for each blank cell defined as the average of the immediate value above the empty cell, and the immediate value below the empty cell.
Thanks!!
Configuration: Windows XP Firefox 3.0.4
Figured it out myself.....used this code:
|