Good Morning,
I tried to modify this code to allow me to record an old value of a cell when the cell changes to a new one. The cell changes via a calculation on the spreadsheet. I would like the old value recorded in the next column (in this case I2:I1000).
Thanks for your help.
Please Login or Register to view this content.
attach please a sample file
If solved remember to mark Thread as solved
Hi, MannyP,
Worksheet_Change is for direct entries into a worksheet, Worksheet_SelectionChange for selecting cells on a worksheet - if itīs formulas you would like to monitor you should either use Worksheet_Calculate or monitor the cells on which the the formulas rely.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
hi,
Example attached:
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks