whenever I delete rows from the spreadsheet it takes about 1 min?
D David McRitchie Mar 29, 2006 #2 Hi shan, How are you deleting them? Manually or with a macro Manually you can make a selection in the name box to the left of the address bar 202:800 will select rows 202 through 800 Using a macro, you want to turn off screen updating and calculation http://www.mvps.org/dmcritchie/excel/slowresp.htm Some macros for deleting rows Delete Cells/Rows in Range, based on empty cells, or cells with specific values http://www.mvps.org/dmcritchie/excel/delempty.htm
Hi shan, How are you deleting them? Manually or with a macro Manually you can make a selection in the name box to the left of the address bar 202:800 will select rows 202 through 800 Using a macro, you want to turn off screen updating and calculation http://www.mvps.org/dmcritchie/excel/slowresp.htm Some macros for deleting rows Delete Cells/Rows in Range, based on empty cells, or cells with specific values http://www.mvps.org/dmcritchie/excel/delempty.htm
