View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MH
 
Posts: n/a
Default why don't my totals change when I enter additional data?

I imagine this is a custom function you have created?

If so, add the following as the first line in the code.

Application.Volatile



MH


"Melozia" wrote in message
...
I have to click on the formula, re-enter a digit (any one) and then hit
eter
for my totals to be current after inputting additonal data.