Dear Microsoft, please fix the Advanced Filter in Excel. Copying filtered data to another worksheet should be simple but it’s not. Fixing this would help out many of your beginning and intermediate users and some of us old dogs who seemingly haven’t learned the trick.
Speeding up VBA with the PrintCommunication Property in Excel 2010
I have an Excel file that creates different reports from a data table using a macro, and before Excel 2010 was released the “time-hog” was running VBA code for the print settings. Tell me you’ve added something like the following code and had your execution time slow exponentially. With ActiveSheet.PageSetup .CenterHeader = “&””Verdana,Bold””&12&A” .CenterFooter = …