One of the nice things about cleaning up the code by removing the .selects and
..activates is that the code usually gets lots smaller.

And easier to update later.



Ed Davis wrote:

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

--

Dave Peterson