PDA

View Full Version : [SOLVED] VBA to select first cell with data in a row



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.