Hi Frank

Just looking at your post, you have one named range called "dist_date"
but your code refers to a range called "dist_data". As these two
names vary you are asking alot of Excel. I would suggest you have a
named range in another workbooked called "dist_data".

If you mean the referenced area to be "dist_date" then change the
reference in your code and it will work ok.

Take care

Marcus