How do I force the update of the balance available in the excel sheet. The guide says a U in cell J2 should do it. I am trying to put =if(condition,"U",) into that cell but it doesn't seem to work.
David M
Balance Available
Moderator: 2020vision
3 posts
• Page 1 of 1
Balance Available
by MagicMitch » Tue Apr 06, 2010 5:30 pm
- MagicMitch
- Posts: 7
- Joined: Sat Dec 20, 2008 4:09 pm
by milfor » Tue Apr 06, 2010 6:17 pm
The problem is that after the update the U is removed automatically. (Otherwise it would update nonstop.) Therefore the cell is empty and the formula is gone. Hence updates can't be triggered with a cell formula, only by VBA.
- milfor
- Posts: 437
- Joined: Mon Jun 26, 2006 1:44 am
- MagicMitch
- Posts: 7
- Joined: Sat Dec 20, 2008 4:09 pm
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 30 guests