Thanks for the feedback Tom. I suspected that was the
answer. ;)

-----Original Message-----
the best you can determine is if the results are
consistent with the use of
Autofill.

--
Regards,
Tom Ogilvy


"Gilroy" wrote in message
...
I have the need to determine if a specific range of
cells
have values resulting from an autofill action.

Example:
If Range("C7").Value = "Jan", and AutoFill was used to
make C7-K7 = "Jan","Feb","Mar",etc

How can I tell programmatically that AutoFill was used
to
perform this action?

I can easily do this:

ThisWorkSheet =
Excel.Application.ActiveSheet

With ThisWorkSheet
If .Range("C7").Value = "Jan" _
And .Range("D7").Value = "Feb" _
And .Range("E7").Value = "Mar" _
And .Range("F7").Value = "Apr" _
And .Range("G7").Value = "May" _
And .Range("H7").Value = "Jun" _
And .Range("I7").Value = "Jul" _
And .Range("J7").Value = "Aug" _
And .Range("K7").Value = "Sep" Then
MsgBox("Cool")
Else
MsgBox("Not Cool")
End If
End With

But, that doesn't reach my goal of finding out if
AutoFill was used.

Thoughts?


.