To refresh Excel file every 1 second

[BarbD]

I am a novice. This is code I found through a Google search:

Sub Calculate_Range()


 Range(“A1:I25").Calculate


 Application.OnTime DateAdd(“s”, 1, Now), “Calculate_Range”


End Sub

When I try to run this code I get a Compile error Syntax error. Can you help me to update this code to include a range that would include more of the sheet, like A1:I5000?

MS Excel 2013

 

[dUBBINS]

Okay, I never tried this, but after googling your question, I found this:

Application.OnTime Now + TimeValue("00:00:01"), "Calculate_Range"

And you can just change the range in your code from I25 to I5000 or whatever you want.

I have no idea what you are forcing it to calculate; however, that range is 40k cells. If you have too many formulas in there, this is may slow down Excel too much to calculate every second. But again, I have no idea what you are doing. And if it freezes up, hit ESC.