I use a range variable or two...

'at the start
dim CurSel as range
dim ActCell as range

set cursel = selection
set actcell = activecell

'do all your stuff

application.goto cursel
actcell.activate



wrote:

I appreciate your experience and comments. I am in fact unable to use
my computer effectively while my program is running.

I am opening up approximately 50 or so files one at a time, processing
data on from these files, adding charts and performing various
algorithms, and then saving the file as an xls. I use the
activeworkbook and activeworksheet throughout the code (errr).

anyhow, to answer your question, at the end of my program, I do change
screenupdating back to true before I apply worksheet.activate. What is
happening is that once my program begins, various worksheets in the
program become active, and upon termination, i want to user to start
off where he began. if there is another way, i'd be obliged to know
it.

Thanks.

Smokii

--

Dave Peterson