need to modifiy vba code
17.03.2016 21:25:22
soletto
i have only a short question:
I need to modyfie this code row:
zmax = dies.Columns(1).Find(what:="?*", LookIn:=xlValues, _
lookat:=xlWhole, searchdirection:=xlPrevious).Row
I want to replace the "?*" so that is searching for this text:
"NaN"
in the search rows there is this code: =WENN(A3="NaN";"NaN";Übersicht!$B$45)
zmax = dies.Columns(1).Find(what:="NaN", LookIn:=xlValues, _
lookat:=xlWhole, searchdirection:=xlPrevious).Row
not working
Best thx