Hi all!

There is a macro that is to work with 2 worksheets in the
same workbook. If worksheet1 is active, when the macro is
executed, then the code doesn't work properly for
Worksheet2. And if worksheet2 is active, when the macro is
executed, the code doesn't work properly for worksheet1.


The transfer of control between worksheets is not
happening properly.
Is there a problem i need to address, while transfering
control between worksheets?

thanks in advance,
Anita.