excel - Find function - error 91 -

-

i use code find value in range. works fine if searched value of single digit or text. "error 91 object variable or block not set" whenever searched value of 2 digits. tell wrong? make things clear have uploaded file here: https://www.dropbox.com/s/5nkja2xumcyap73/find%20error%2091%20for%20double%20digits.xlsm appreciated!

dim search_range range dim search_start range dim search_value range  set search_range = shdaten.range("e1:t1") set search_start = shdaten.range("e1")  set search_value = search_range.find(what:=shschl.range("d25").value, after:=search_start, _         lookin:=xlvalues, lookat:=xlpart, searchorder:=xlbyrows, _         searchdirection:=xlnext, matchcase:=false, searchformat:=false)

error found! cells contain searched value must formated "text" (by right click on cells/range , go "format cell" , select "text").


Comments

Post a Comment

Popular posts from this blog

Unable to remove the www from url on https using .htaccess -

-
i want remove www site url. ie. https://www.domainname.com.au https://domainname.com.au . i have tried various .htacces code nothing work me. here present code remove www http not work https. rewriteengine on rewritebase / rewritecond %{http_host} ^www\.(.*)$ [nc] rewriterule ^/(.*)$ http://%1/$1 [r=301,l] rewritecond %{https} off rewriterule ^(.*)$ https://domainname.com.au/$1 [r=301,l] rewriterule ^code-of-conducts/(.*)/$ code-of-conducts.php?type=$1 rewriterule ^parents/post-a-job/(.*)/edit/$ parents/post-a-job.php?action=edit&id=$1 rewriterule ^parents/post-a-job/(.*)/$ parents/post-a-job.php?job_type=$1 rewriterule ^parents/open-jobs/(.*)/delete/$ parents/open-jobs.php?action=delete&id=$1 rewriterule ^parent-profile/(.*)/$ parent-profile.php?id=$1 rewriterule ^parents/job-details/(.*)$ parents/job-details.php?applied_id=$1 rewriterule ^sitterprofile/(.*)/$ sitterprofile.php?id=$1 rewriterule ^sitter/job-board/state/(.*)/page/(.*)/$ sitter/job-board.ph...
Read more