worksheets("ABC").select and the screen will focus on it

Hi all,

I am writing a simple macro to conditionally copy some data from one workSheet to another workSheet in the same Excel file.
Here is the code:

Please Login or Register  to view this content.

When the code is executed, I saw the screen was blinking with two worsheets kept switching.
Is it possible to make the screen focus on the Kitty worksheet while the code is excuting? I don't want to see the screen blinking.

I am new to macro programming.
Please help and advise.
Thanks
Kitty

At the beginning of your code, put -

Please Login or Register  to view this content.

Before the End Sub, put -

Please Login or Register  to view this content.