macro to return to where user was working

i have an excel doc. with three sheets...
i may start that macro on any sheet any cell
the 1st thing that macro does is to go to sheet1 and after running the whole code it calls another macro... macro2

now macro2 runs in an infinte loop and runs evry 20 sec. the problem is every 20 sec the cursor comes back to sheet3.. i want the macro to return to the place where the user was working.. best wud be that the user can work seem lessly...

Originally Posted by hotmalepiyush

i have an excel doc. with three sheets...
i may start that macro on any sheet any cell
the 1st thing that macro does is to go to sheet1 and after running the whole code it calls another macro... macro2

now macro2 runs in an infinte loop and runs evry 20 sec. the problem is every 20 sec the cursor comes back to sheet3.. i want the macro to return to the place where the user was working.. best wud be that the user can work seem lessly...

plz help
is not much of a title,
please edit your title,
Also, how is anybody supposed to know what is wrong with the code if you do not display it?

cannot do without select

macro is something like this(on another pc)

Please Login or Register  to view this content.

note: this is just to give an idea of the code

hotmalepiyush

You need to read the Forum Rules & abide by them. Now you haven't used Code tags. I will add them this time, but in future you may well find your post locked if you do not follow the Rules!

i was able to use ur way in all cases except one

when using paste(i need background colors fo cells) how can i avoid select// please help

my code is

Please Login or Register  to view this content.

the last two line when replaced with :

range("e2").paste doest work..

is there any way i can use special paste n copy colors at the same time??

Originally Posted by hotmalepiyush

i was able to use ur way in all cases except one

when using paste(i need background colors fo cells) how can i avoid select// please help

my code is

range("a2:a22).copy
range("E2").select
activesheet.paste

the last two line when replaced with :

range("e2").paste doest work..

is there any way i can use special paste n copy colors at the same time??

Are you actually reading the posts???
Please place your code between the code tags.........

BTW did you know you can copy and paste code instead of rewriting it?

Please Login or Register  to view this content.