James,

Never knew you had to put in a range. I selected all the rows starting
with the top line being the one I wanted the arrows and darn if it
didn't work. Thanks a whole bunch.

Normally, I would only select the row I wanted the arrows and hit data
--> Filter --> Autofilter and it has always worked. Somehow, I must of
deleted the ranges. Where does this range value your talking about get
stored? and I can I default it to the the entire worksheet?

Paul