as far as i can see here dtoday has no value of any type, it may have been declared and set elsewhere, which is fine as long as it is still in scope
I thought it was a "Built In" name representing todays date internally.
Maybe like
numOfDays = DateDiff("d", dToday(), dCell.Text)
But I got this code from a Resolved thread, and they didn't have anything like
Dim dToday = dToday()
listed anywhere. So I don't know.

Code:
for each dcell in ws.range("b6:b82")


	

		

			

			
				' your comparing, colouring code
			
		

	


next
Well, I'm not comparing the colouring..
I'm trying to:
1. dcells contains dates 10/22/09
2. DateDiff is supposedly to compare the date in the Cell with the Internal Computer Date.?.? And bring back the difference in "d"Days.
Then the Case statement is supposed to "Set" the Cell "Text" Colour.
Basically I'm trying to build an alarm system: Yellow= "Deadline is Approaching" Red= "You have a Week" kinda thing.