Geekamo
asked on
Code To Update/Refresh Spreadsheet
Hello Experts!
I have no idea if this is even possible. I am hoping there is a code that I could put into my spreadsheet, that (assuming macro's are enabled) this " code " looks at range E:I, and after any cell has been entered with a value, then the spreadsheet automatically refreshes itself.
The reason, is because I have a cell in my spreadsheet that references "=NOW()" - and I need that cell to refresh with the current value. Cause there are certain cells dependant on that when values are entered into range E:I.
I hope that made sense.
Thank you in advance for your help!
~ Geekamo
I have no idea if this is even possible. I am hoping there is a code that I could put into my spreadsheet, that (assuming macro's are enabled) this " code " looks at range E:I, and after any cell has been entered with a value, then the spreadsheet automatically refreshes itself.
The reason, is because I have a cell in my spreadsheet that references "=NOW()" - and I need that cell to refresh with the current value. Cause there are certain cells dependant on that when values are entered into range E:I.
I hope that made sense.
Thank you in advance for your help!
~ Geekamo
Are you familiar with Application.OnTime?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
@ MartinLiss
I assume that's something in the code section of excel, but no. My skill level for excel, is someone who knows their way around a 'little' more then the average user who is forced to use excel.
I assume that's something in the code section of excel, but no. My skill level for excel, is someone who knows their way around a 'little' more then the average user who is forced to use excel.
ASKER
@ tdlewis
Uh oh. For some reason, I had it in my head that the value =NOW() returns, it's the value from right then. And I assumed that it wouldn't change unless something happened, making it refresh. I just checked, and updated that range 2 minutes later, and it did update to the current time. So there was no need to even post this question. lol
I'm sorry for wasting your time. :)
~ Geekamo
Uh oh. For some reason, I had it in my head that the value =NOW() returns, it's the value from right then. And I assumed that it wouldn't change unless something happened, making it refresh. I just checked, and updated that range 2 minutes later, and it did update to the current time. So there was no need to even post this question. lol
I'm sorry for wasting your time. :)
~ Geekamo
What I'm suggesting is the update the time at a specific interval rather than depending on a worksheet event.