I need a function that records the number of times a cell in a worksheet has a value change.
I got it, how to count for 1 cell but my brain just can not crack how to make it work for the entire column.
So as an example :
I have a value in D8 and need to record it in E8
and so on for the entire column D9 to E9
I'm really new to all this code stuff so help would be very much appreciated.
P.S only my solution, for now, is to do it for each cell in particular like this:
Count of each change made in a cell to another cell for entire column
- Thread is marked as Resolved.
Welcome to the Forum. Please read the Forum Rules to understand how the Forum works and why I have added Code Tags to your post
All VBA code posted in the forum must be wrapped in code tags, which you omitted, including single-line code snippets.Be sure to use them in future posts.
How to use code tags
Just highlight all of the code and press the <> in the post menu above button to add the code tags.
You could check an entire column using something like this:
It will probably be better to make sure the code only works on single cells as well as checking it is in Column 4
Big thank you royUK and rory both codes worked perfectly thank you so much,
Big thank you once again
Don’t have an account yet? Register yourself now and be a part of our community!