| View previous topic :: View next topic |
| Author |
Message |
jb007
Newbie
Joined: 25 Jan 2008
Posts: 1
|
 Posted: Fri Jan 25, 2008 5:15 pm Post subject: Equivalent for application.volatile |
 |
|
Hello, it's my first post!
Does any one know the equivalent code for application.volatile as used in excel?
I want to force a cell to refresh with a random number but it's applicable to lots of cases. |
|
| Back to top |
|
 |
Villeroy
Super User
Joined: 04 Oct 2004
Posts: 10065
Location: Germany
|
| Posted: Sun Jan 27, 2008 6:07 am Post subject: |
|
|
=<some_numeric_formula>+0*RAND()
=<some_text_formula>&T(RAND()) |
|
| Back to top |
|
|
|
