Im trying to find a way to count cell value changes, eg. if cell A1 is changed, B2 value would be 1. When A1 is changed again, B2 is 2, etc.
I've managed to do it with this:
but it's not working if there is a formula inside cell (eg. =IF(C1="Yes";1;0)).Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "A17" Then [E14].Value = [E14].Value + 1
End Sub
Could you redirect your worksheet change formula to look at the place where the value is changing (C1 in your example) instead of the formula that is looking at the change?
If Target.Address = "C1" Then [E14].Value = [E14].Value + 1
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
C1 also contains formula
What goal are you trying to accomplish by doing this? Is it just to test because there might be a better way around it.
Well, it is connected with this thread:
http://www.excelforum.com/excel-form...ell-value.html
What im trying to do now is to count how many times green cell shows up (and only green cell).
This may be helpful from here:
http://www.exceltoxl.com/index.php?p...&c=1&tb=1&pb=1
Please Login or Register to view this content.
Could you do a while loop and set it equal to something like
While Interior.Color(Cells_____) = 'green
'count number of cells green
B2='num of green cells
wend
nigelbloomy, thanks for a link, ill try something with that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks