I wouldn't be surprised if your code could be rewritten so that no .selects or
..activates would be included.

Ed Davis wrote:

The reason I use .select and .activate is that my macros open another file
and then I copy values from several areas from several sheets and import the
data to the other open file. So I am bouncing in and out of both workbooks.

"Dave Peterson" wrote in message
...
I think I'd try to rewrite the macro so that it didn't use .select's and
.activate's. Just updated the objects directly.

But one more way:

'declare some variables
Dim mySelection as range
Dim myActCell as Range

'do this at the top.
set myActcell = activecell
set mySelection = selection

'do lots of stuff

'right before you finish
application.goto mySelection
myActcell.activate



Ed Davis wrote:

I have a workbook that has over 90 sheets. After invoking a macro that
changes to other sheets I would like to return to the sheet where the
macro
first started from.

Does anyone know how I can do this?

--

Dave Peterson

--

Dave Peterson