VBA slowing a sheet?

[stevod]

Hi,

I've made a sheet, macro enabled and have a few macros that run some code. Its a blank sheet, data gets pasted in press a button and the code runs (i'm just being very simple here). There's not a lot of data, columns C:AZ and random in length, the sheets it comes from are like 20kb.

The issue i'm having is when i paste the data in and run the code, this works fine. It deletes columns, cuts and moves them. Finds changes in a specific column and inserts borders for each change and a few more things. Nothing too taxing.

I have a reset code and this is where it slows down, it literally selects the columns
Columns("C:AZ").Select
Selection.Delete Shift:=xlToLeft
Range("C1").Select

Then when i paste different data it takes a good 10 to 15 seconds, then to run the macro it will have a grey screen and takes 3 or 4 times as long to do it.
my only fix is to close it, reopen and it works fine... once

Anyone encountered this before? And is there a simple solution?

Thanks for looking, Steve

 

[Michael M]

Firstly, have you implemented the changes that have recommended to you
secondly, if you press CTRL + End on the sheet in question, which cell does it highlight.
I'm guessing you are processing much more of the sheet than is necessary

 

[NdNoviceHlp]

If U remedy your code as Micheal M has suggested and continue to insist on using copy and paste, then U will need to clear the clipboard or it will crash after repetitive use. U are not clearing the clipboard with your current code. Here's a link to some code to remedy your clipboard woes. Better yet, load your data in an array and manipulate the array to produce your output without using any copy/paste. HTH. Dave

VBA code to merge workbooks quits unexpectedly

Hi all, I have the code below that loops through workbooks in a folder and copies data from a specific sheet in each file into a master workbook. For some reason Excel will randomly close down while the Macro is running and leave me with a workbook in a recovered state so I have no idea at...

www.mrexcel.com