jsabo
11-30-2014, 11:19 PM
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.
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.