Table calculation question

[BrettQX]

Non VBA person here. I think I have stumbled my way into VBA code that does what I want it todo but only triggers manually. I need itautomatically to trigger.
I think my reading tells me that the tables don’tcalculate automatically. Is there a wayto calculate table on change to a range?


Thanks for your time…

 

[Joe4]

You can automate VBA code to run with Event Procedures, which can run automatically based on certain cells being manually updated or selected.
There is also a "Calculate" event that runs automatically when a re-calculation is performed on the sheet.
See: http://www.cpearson.com/excel/Events.aspx

If you need help, please post more specific details, such as your code, etc.