Be sure to avoid things like .Select - it just slows the code down by needing to fiddle with the spreadsheet while doing everything else behind the scenes. There's a good question on StackOverflow addressing this - http://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba-macros https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba-macros .
Be sure to avoid things like .Select - it just slows the code down by needing to fiddle with the spreadsheet while doing everything else behind the scenes. There's a good question on StackOverflow addressing this - http://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba-macros .
Be sure to avoid things like .Select - it just slows the code down by needing to fiddle with the spreadsheet while doing everything else behind the scenes. There's a good question on StackOverflow addressing this - https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba-macros .