You will need to post a separate question about that (I think this one will
get lost within this thread) as I have not dealt with charting in VBA
before... my post in this thread was simply a syntax comment.

Rick


"Daniel" wrote in message
...
Thanks Rick
I should use date is good enough.
Another question:
How can I reset the function

Interior.ColorIndex

to begin color my bar chart again?
Thanks
Daniel

"Rick Rothstein (MVP - VB)" wrote:

I want to compare today date with date in a column (column name:
"date_last_op") and fill the bar chart with pattern if 3 days but
alway
have error at
Set Rng2.Value = (DateDiff(TODAY, "date_last_op", "d"))

Don't know how to fix. Need your help. Please respond with your
sugestion

You are trying to use Excel worksheet function ordering on the VBA
DateDiff
function... they are not the same... as well as a worksheet function
(TODAY)
which doesn't exist in VBA The first argument in DateDiff is the
Interval,
then the start (lowest) date, followed by the end (highest) date. Also,
TODAY does not exist in VBA... use either Date (which returns today's
date
only) or Now (which returns today's date and time).

Rick