How to copy data to non active worksheet????

[vid]

Hi

I have a db with 2 worksheets (which I am attaching). It has a simple macro based on a filter placed behind the "Submit" button. However when you click the button, you'll see that "sheet2" opens and closes very quickly. Even though you can't see it this looks quite bad.

I want to make it more professional looking so I want that when I click the submit button the whole procedure happens but without opening and closing "sheet2". Hopefully you can understand what I'm saying.

I am quite new to Macros. However, from my understanding, if I use Worksheets("sheet3").Range("B9").Paste instead of the "Activesheet" method, this problem should get solved. Tried a lot of different permutations and combinations but it doesn't work!!!

Please please please please help!!!!! spent hours on this problem but can't seem to figure it out...

 

[chergh]

Worksheets("sheet3").paste worksheets("sheet3").Range("B9")

 

[vid]

Umm nope.. still the same thing happening!! any other suggestion??!!

 

[chergh]

Is the sheetname correct?

 

[chergh]

Actually now I read more closely you just want to turn screen updating off.

use:

Application.ScreenUpdating = False

your code

Application.ScreenUpdating = True

 

[vid]

Perfect!

Thanks a ton.. You're a lifesaver