Copy and Paste using macro very slow is this code correctly done? Need help with a edit

[Mr_Bill]

I have piece of code that I made so I am sure it is not efficient even though it does work it is very slow locks up excel at times. It is only copying around 15 words and Columns A:G do have formatting but only up to rows 101. Can this be made more efficient speed wise and how can I edit the ranges say A:F to A150:F150 and G:L to G150:L150 when I change those to that it no long keeps the column widths. Right now it is copying like 18k row or more I dont need which might be the lag issue even though they are empty.

Please Login or Register  to view this content.

Thank you for looking

[Winon]

Hello Mr_Bill,

Please try:

Please Login or Register  to view this content.

[Norie]

Will the no of rows to copy change?

[Mr_Bill]

Winon thank you but that didnt fix this picky thing only one set formatted right and that is the first set you didnt add the 200 to. Here is how it ended up
1bQBMow.png

Norie no the amount to copy will not change. If for any reason I need to add more to the new sheet I can just use the format painter and add more by hand.


On a side note I think I resolved the problem I made a new sheet and hand copied the columns and rows to the new sheet. Deleted the original MasterSheet and rename the new one to MasterSheet and went from 5 minutes to around 5 seconds to create new sheet. I tried this as I noticed on the original I had a tiny slider so something else was on that page I think.

I also added this tid bit to the end of that Application.CutCopyMode = False because I was getting an error on exit something like "the image is too large and will be truncated" think that is how you clear the clipboard. Like hitting esc after you paste something. Just think something went fubar when I created the first mastersheet.

[xladept]

OOOH Mr. Bill - you should mark this thread as solved(go to the top and click on the thread tools)