I've been benchmarking some functions in vba. When benchmarking if statements (through a loop that ran 100,000,000 times) the time differences were:
# if statements - time 1 - 3.36 2 - 8.41 3 - 8.67 4 - 11.14 why is the difference between 2 & 3 almost nothing? This timing is consistent with one line if statements and if/end if -Matt --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
