The cods is going to default to the active sheet. If you've run it from abutton on a different sheet, then that different sheet will be the activesheet. You might need to specifically qualify the range/cell calls with thesheet you want.