It wouldn't surprise me either but I have spent hundreds of hours in past
couple of years on these workbooks that I would not know where to start. I
was very good with macros and formulas in Lotus and it was H--- trying to
convert them to excel.

I have hundreds of lines in macros in these sheets.


"Dave Peterson" wrote in message
...
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