I guess this is where my understanding is less than adequate. Where would this be called in the module? Also, there could be multiple instances of "z.1", etc. throughout the spreadsheet (though never more than one per cell).
Attached is the current semi-working xlsm for reference.