Working between Worksheets of the same workbook

A

Anita K

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.
 
R

Robert Rosenberg

Anita,

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do Excel define the application area? 3
Slow code when used as VBA code instead of macro (copying visible columns) 3
Copy a row down a column for the same number of rows of data in another workshee 6
Select Cell in first blank column of a row 2
MS Excel VBA Worksheets group tables in one table. 1
trigger worksheet activate event in another worksheet 2
consolidate data (i.e. a single cell) from multiple spreadsheets intoa single sheet 4
Query starts a "read only" copy of the source sheet 1

Top