hi Dave
Thanks for your suggest & i guess the only place i can put the code now is in Worksheet Activate instead.
I forgot to mention that the filled range to lastrow is non-contiguous,& may have blanks in GF, so i tried inserting your line into this new attempt but it returned COMPILE ERROR: ELSE WITHOUT IF. I tried repositioning & removing the END IFs and IFs but to no avail, can you point me out where it's wrong (i need the GG to be assigned a zero if its adjacent non-contiguous GF happens to be a blank).
And, i also ran into another issue that is if just 1 cell in GF column returned a #VALUE error because of input errors by user in precedent cells elsewhere, i will get the Excel error msg RUN-TIME ERROR '13': TYPE MISMATCH. What is causing above 2 issues?
Stewart
Bookmarks