very interesting... I just tried yours and it works in your spreadsheet. the only difference between mine and yours is that all of my data is in a table, and some of the values are formulas (but thats covered with LookIn:=xlFormulas). any ideas? I'm still playing around with it... does excel version matter?


Quote Originally Posted by mongoose36 View Post
I'm not sure what would be causing this behavior. It works fine in my test (see attached).

http://www.excelforum.com/attachment...1&d=1460474277