Finally figured it out. Only took me two weeks:
changed
LookIn:=xlValues
to
LookIn:=xlformulas