Very Slow column insertion

[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

 

[Frank Kabel]

Hi
you may post your current macro. As general tip:
use
application.screenupdating=false
'your code
application.screenupdating=True