can you keep the current sheet viewable whilst a macro updates or copies from another sheet, when i try this the screen jumps.
