Maybe you can surround the code that causes calculation with:

application.enableevents = false
'whatever code you have
application.enableevents = true



Parker wrote:

I'd like to update multiple cells using a Worksheet_Calculate code. My
problem is that the sheet is calculating after each one is updated and
triggers the macro again so it never stops. It works perfectly if I only
update one cell or switch to manual calculate. Is there any way around this?

--

Dave Peterson