Range(Selection, Selection.End(xlDown)).Select goes to 65536 instead of last filled row

Thanks you all!

It seemed there was a ")" to many at the end of the formula causing the 1004 error..
I am using Arlu's version now. but I think Norie's would do as well.