hi
i have been workin on this for 2 days now and its driving me nuts!
i have a code writen that, when any single cell is changed withing the predefined range, it will email me with the exact cell address and the values of row 2&3 in the corresponding column, and it works just fine.
where the problem comes in is when more than 1 cell is edited simultaneously, i.e. copying 4 or 5 cells in at a time. then it does nothing at all.
what i would like it to do is send me the information above, and the range of cells that were edited.
here is the code:
help!!
Bookmarks