Working between Worksheets of the same workbook
 

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.

Working between Worksheets of the same workbook
 

Anita,

Post your code so we can address the issue with more detail. Thanks.
_______________________
Robert Rosenberg
R-COR Consulting Services
Microsoft MVP - Excel

"Anita K" wrote in message
...
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.