Hi. I have a worksheet measuring staff attendance on various courses. Using date-today, a 'days lapsed' value is calculated in column D. If the value of the cell in column D exceeds 365 days, an email is generated to that member of staff using the following code in a module;
This works fine on a single column, but if I wanted to add another set of columns e.g. if I had columns F, I and J set to measure different lapses e.g.100, 200 or 300 days respectively, could I incorporate this code into the same module? I have tried using a new module for each column, but come up withPlease Login or Register to view this content.
warnings. Any info gratefully received,Ambiguous name detected; Testfile
Mattbro
Bookmarks