MrExcel Publishing
Your One Stop for Excel Tips & Solutions

opening current worksheet in macro


Posted by Elise on August 23, 2001 1:53 PM

Hi,
I'm trying to write a macro which allows me to go from worksheet A to worksheet B, copy some cells, and return to worksheet A and paste the cells. When I try running the macro from worksheet C, it continues to paste the cells into worksheet A instead of C. Advice?
Thanks.


Posted by neo on August 23, 2001 1:55 PM

if i could see your code, i could fix that :-)

neo

Posted by George on August 23, 2001 4:51 PM

I understand that you need to copy from sheet B and paste to whatever happens to be the active worksheet. If so :-

Worksheets("B").Range("A1").Copy ActiveSheet.Range("A1")