Can't select worksheet
The following code is called from Sheet2:
1. Worksheets("Sheet1").Unprotect
2. Worksheets("Sheet1").Activate
3. Cells(3, 1).Copy 'THIS CELL IS COPIED FROM SHEET2....and is WRONG
4. Worksheets("Sheet1").Cells(I, 1).Copy 'THIS CELL IS COPIED FROM
SHEET1....and is CORRECT
Why doesn't line 3 do the copy from Sheet1 as I had intended?
Thanks,
Bernie
|