Excel VBA Calculate Problem
I have a simple two tab (sheet) excel97 file. The first tab contain
report data, the second tab contains summary data that uses a formula that I created in a standard module. The situation I have is that when I update the data in the first tab the data using the formula in the second tab does not autocalculate. I want to know if there is some procedure I can latch onto and updat or write a new one from scratch to update the data when the excel fil is either opened or closed, or after an update occurs on the first tab. I want to cause the cells in the second tab to b automatically calculated when a change occurs. -- Deep Though -- Message posted from http://www.ExcelForum.com |
Excel VBA Calculate Problem
DeepThought < wrote:
I have a simple two tab (sheet) excel97 file. The first tab contains report data, the second tab contains summary data that uses a formula that I created in a standard module. The situation I have is that when I update the data in the first tab, the data using the formula in the second tab does not autocalculate. I want to know if there is some procedure I can latch onto and update or write a new one from scratch to update the data when the excel file is either opened or closed, or after an update occurs on the first tab. I want to cause the cells in the second tab to be automatically calculated when a change occurs. Add " Application.Volatile = True " to your user defined function. Regards, -- Beto Reply: Erase between the dot (inclusive) and the @. Responder: Borra la frase obvia y el punto previo. |
Excel VBA Calculate Problem
|
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com