Hello,


I am looking for some VBA to do the following:


Cell L2 is the active cell. I need it to look left (K2, J2, etc.) until it finds the first populated cell. I need it to then assign that cell value ( it will be a date ) probably to a variable which I can then subtract from =today(). Any ideas? Thanks.