Hi Guys,
So i have code (from this site) to record the value of cell 'R10' when i manually change it. However, it will not record the value of this cell when it changes automatically.
The cell itself is a SUM - but the data to the referenced cells in the SUM are changing via a data link.
Is there a way to record the values of a changing formula?
Please Login or Register to view this content.
Thanks
Hi there,
Your issue is in one row of Your code:
If You want to run the code in R10 has changed, change row above to:Please Login or Register to view this content.
Hope it helpsPlease Login or Register to view this content.
Regards
Miroslav R.
(If You like my solutions, feel free to add reputation.)
Thanks for response...unfortunately still not working:
Please Login or Register to view this content.
Thanks for the response...unfortunately still not working:
Please Login or Register to view this content.
can you run this off the address that is involed in the SUM, so say its =SUM(A1:A100) say
if target.address(false,false,xlA1)="A1:A100" then
end if
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Oh...
sorry for that wrong post!
It only seems to refresh when i press the 'Delete' key - is that refreshing the sheet in some way that the changing values isnt?
Any further input would be appreciated.
Cheers
Latest...i am using the current forumla:
At it still only works when i manually refresh field R10..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