Very Slow column insertion

  • Thread starter Thread starter Tim B
  • Start date Start date
T

Tim B

I have a spreadsheet that is about 17000 lines. The macro
I am using to update the sheet takes forever, and I
isolated the problem to Selection.insert command which
inserts a blank column into the data. I inserted columns
into the spreadsheet manually and found they still took a
very long time. Even slimming down the sheet to about
8000 lines, it took four to five minutes to insert a
column.

Any ideas on how to reduce the time would be appreciated
 
Hi
you may post your current macro. As general tip:
use
application.screenupdating=false
'your code
application.screenupdating=True
 
Back
Top