I have the following code which gets the formula of a chart. If I enter the function it should write the formula into the cell, however, if the chart is updated the result doesn't change until I go into the cell and press enter. How can I solve this?
Please Login or Register to view this content.
Last edited by VBA Noob; 12-03-2007 at 08:58 AM.
Phil
I have the following code which gets the formula of a chart. If I enter the function it should write the formula into the cell, however, if the chart is updated the result doesn't change until I go into the cell and press enter. How can I solve this?
Please Login or Register to view this content.
Add
as the first line of the function.Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks