LinkBack URL
About LinkBacks
Hi,
Wonder if it was possible to create a logger for the RandBetween Function in Excel. Every time I refresh the RandBetween Function I would get a new number. Wondering if all the old numbers can be logged below with the timestamp they occurred.
Hi,
Wonder if it was possible to create a logger for the RandBetween Function in Excel. Every time I refresh the RandBetween Function I would get a new number. Wondering if all the old numbers can be logged below with the timestamp they occurred.
This requires VBA, and you must save the file as .xlsm.
Add this code to the code module for the worksheet containing your data:
Sample attached.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks