Group,
What are examples of VBA macros that are efficient and no
efficient. I'm learning now that as I do more and more error detectio
on spreadsheets that have less than 2000 rows and less than 52 columns
speed is an issue. Presently my test spreadsheet with all th
comparing and looking for errors takes about 6 minutes to completel
run. I'm a beginner at VBA and therefore believe many of my bits o
code are probably poorly written. Examples of code optimization I'
sure can reduce my macro cycle-time significantly.

A budding VBA programmer.......

Ton

--
ajociu
-----------------------------------------------------------------------
ajocius's Profile: http://www.excelforum.com/member.php...fo&userid=1769
View this thread: http://www.excelforum.com/showthread.php?threadid=39211