@JaredBusch said:
@garak0410 said:
A lot of these VBA projects have many For/Next loops that take an eternity to step through (F8)...I thought STEP OVER (SHIFT-F8) would get me through these but alas, doesn't seem to do it...either I am impatient for these For/Next loops take forever to get through, even holding down F8. Is there a faster way to get through these?
Been a while since I was in VBA but I think it is F5 to run to cursor? Stick the cursor in front of the next line after the loop and hit F5 (or whatever run to cursor is).
@garak0410 said:
dteEnd = Application.Sheets("Report").Range("$J$27").Value
This is a logic error. A cell can always be converted to a date if it is 0. it converts to midnight like that if you dump it into a date variable.
I would need to see the logic to troubleshoot more. Been a while since i used VBA.
I'll give F5 a try.
What is interesting about this dteEnd thing, is at some breakpoints, it does show 1/6/2015 but near the end of the Macro, it gets assigned the 12:00 AM. And because someone else wrote this like 7 years ago and without knowing their logic, this has been a chore.