jsabo
07-01-2015, 04:05 PM
Hey guys,
Don't have any code written yet, since I'm not sure where to begin. What I need is code that will loop through a range which contains a date as MMM-YY. Right now, I have Cells A4:A15 which contain Jan-15 through Dec-15. When the macro runs, I would like for it to look at the sysdate and assign the row # that contains the sysdate MMM-YY to a variable for me to use.
For example, since I am running this now in Jul-15, it would look through A4:A15 and assign the number 10 to a variable, since that's the row in which Jul-15 is contained.
Please let me know if this needs more clarification and thanks in advance.
JS
Don't have any code written yet, since I'm not sure where to begin. What I need is code that will loop through a range which contains a date as MMM-YY. Right now, I have Cells A4:A15 which contain Jan-15 through Dec-15. When the macro runs, I would like for it to look at the sysdate and assign the row # that contains the sysdate MMM-YY to a variable for me to use.
For example, since I am running this now in Jul-15, it would look through A4:A15 and assign the number 10 to a variable, since that's the row in which Jul-15 is contained.
Please let me know if this needs more clarification and thanks in advance.
JS