View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Nick Hodge Nick Hodge is offline
external usenet poster
 
Posts: 1,173
Default Infinite loop using Worksheet_Calculate

The worksheet_calculate event will fire, as it's name implies, everytime the
worksheet calculates. If you change a cell that has a dependency then it
will calculate.

Perhaps an explanation of what you are trying to do may help, as I believe a
worksheet_change event, which can control the cell(s) that are changing may
be a better way to go

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England

HIS
www.nickhodge.co.uk

"Parker" wrote in message
...
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?