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")