Go to initial active cell

Hi,

I have a simple macro running goal seek on every Workbook sheet change. When the macro is done it jumps to the changed cell. This is what I would like to avoid.

My code:

Please Login or Register  to view this content.

So my code jumps to cell C11 after every workbook change. I want to avoid that.

Any thoughts?

regards,
Kbka

Hi,

Thanks for the fast reply!

You're right in the fact that the first Range("E77").Select is redundant. So I've deleted it.

The thing is that many cells affect the goal seek, and this goes across worksheets. I would like to go back to the cell that I originally was in. I found this which fixes part of the problem

Please Login or Register  to view this content.

But this doesn't go back to the initial active worksheet. It goes to worksheet 'sheet11'

So I need to add something like "SheetRef = ActiveSheet" or something like that?

Originally Posted by Jakobshavn

Please Login or Register  to view this content.

Note: this is untested

I get a run-time error '1004'

Select method of Range class failed

Originally Posted by kbka

I get a run-time error '1004'

Select method of Range class failed

The error only comes when I go across worksheets. That is if I make a change in sheet11 no error. If I make a change in any other sheet there's an erro.

Originally Posted by Jakobshavn

Please Login or Register  to view this content.

Note: this is untested

Works, I of course just have to ad

set s=Active sheet

CODE

s.select

It Works! I of course just have to also ad

Please Login or Register  to view this content.