When I typed that in my Immediate Window and hit enter...nothing happened.
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"Bob_hc" wrote:
Thanks for your reply, I'll try out your suggestions.
But is there a way to throttle the update rate of a cell. I know if you type
application.rtd.throttleinterval = 1000 in the immediate window it will delay
the update rate of the whole workbook, but I want this instruction for only a
particular cell. Any ideas?
Hope this makes sense!
"ryguy7272" wrote:
Also, you could try something like this:
Private Sub Worksheet_Change(ByVal Target As Range)
Application.Calculation = xlCalculationManual
Application.ScreenUpdating = False
Sheets("Sheet1").Activate
Range("A1").Select
Selection.Calculate
End Sub
Right-click on the tab of Sheet1 and paste the code into the window that
opens (don't put the code in a module).
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"ryguy7272" wrote:
Take a look at this:
http://www.cpearson.com/Excel/OnTime.aspx
If you do it once per second, it will (probably) take over control of your
system.
Good luck!!
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.
"Bob_hc" wrote:
Hi,
I have a spreadsheet with two cells that are linked to an external value.
However I want one of these cells to only update every second. This is
basically so I can see the difference between what the external value is now,
and what it was a second ago.
Any advice?
Thanks