Cowichandave
New Member
- Joined
- Jan 18, 2009
- Messages
- 44
- Office Version
- 2016
Want to show only the value only if equal to F8 else it should be blank until another cell has the same value as F8
Without the if statement it works but shows value of each cell in the range
With the if statement it is blank or whatever value I choose
What am I missing?
Range("F8:F2000").Select
For Each c In Selection
c.Offset(0, -4).Value = c.Interior.Color
If c.Offset(0, -4).Value <> Range("F8").Value Then c.Offset(0, -4).Value = ""
Next c
Without the if statement it works but shows value of each cell in the range
With the if statement it is blank or whatever value I choose
What am I missing?
Range("F8:F2000").Select
For Each c In Selection
c.Offset(0, -4).Value = c.Interior.Color
If c.Offset(0, -4).Value <> Range("F8").Value Then c.Offset(0, -4).Value = ""
Next c