VBA Hangs after paste!!

**ruchi** · 03-05-2009, 12:20 PM

Hi, could somebody please take a look at the code below and tell me what am i doing wrong?

I first copy 3 different columns from a sheet to a sheet called "Temp".
There i used advanced filter to copy the unique set of rows (Till then it runs just fine!)

Then i activate another sheet and try to paste the data. It is now that the VBA hangs for good 5 minutes! I am not sure what am i doing wrong.. I don't understand what VBA could be doing for such a long time! please guide me!

Please Login or Register  to view this content.

**royUK** · 03-05-2009, 12:28 PM

You don't need to activate or select ranges or sheets.

Can you attach an example workbook & indicate wht you want the code to do.

**ruchi** · 03-06-2009, 09:13 AM

I cannot attach the workbook. Let me also mentions, I am pretty new to VBA programming.

I have one sheet with raw data. I need few pivot tables out of it which also needs certain modified columns. Like few pivot tables are at account level, few are at detail level.
Now the code that you thought was similar, is there in quite a few modules

I had to implement things quickly hence could not think of another alternative.

Can you please explain why would select and activate would make it longer? No other modules take this long in spite of having select and activate statements.

In this case, it takes like 5-6 minutes.

Also, if i dont activate the sheet, how would it know on which sheet it should perform the calculations?

VBA Hangs after paste!!

LinkBack

Thread Tools

Rate This Thread

Display

VBA Hangs after paste!!

Re: VBA Hangs after paste!!

Re: VBA Hangs after paste!!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions