Time of modification without VB
Hi,
I want to add a date stamp to my worksheet showing the date it was last modified (which then stays constant until the next time it is modified).
I know how to do this using VB but the issue is that I'm working in SAP Analyzer [a very complex business add-in for Excel], which as far as I'm aware does not accept user VB editing.
Can anyone come up with a clever workaround using only Excel functions?
Cheers
Not really possible. As =TODAY() is a volatile function it would update whenever the worksheet it was on calculated.
Dom
"May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."
Use code tags when posting your VBA code: [code] Your code here [/code]
Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.
If you could be sure that between updates of the "source" cell that cell was blank (eg "apple" -> blank -> "banana") then yes you could do it with iterative calculation else no.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
OK, thanks for the help guys. I think in that case that manual entry is the best way forward!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks