Change the letters of the columns if necessary, and maybe the sheet's name (?) Code: Dim MySearch As Range Dim LookFor As String 'or maybe Variant ? ' Retrieve Black IPM Is ok to have boxes of raw chicken stacked on top of each other Time for a riddle Seventeen year old daughter wants to take international trip to meet someone she Compare Excel | Excel Templates | DownloaderXL Pro Finance Templates & Add-In Bundle | NeuroXL Predictor | Construction Estimating Merge Excel The Easy Way | Trading Add-ins For Excel more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed http://sortoutlookemail.com/vba-error/vba-error-20-resume-without-error.html
I doubt so, but I am getting desperate and therefore trying anything possible. Browse other questions tagged excel-vba excel-2007 runtime-error or ask your own question. asked 4 years ago viewed 4713 times active 10 months ago Linked 1 item not found in “Find” vba 0 Getting Runtime Error 91 0 Copying data to worksheet - Object Let's call one of these sheets "WS1". http://stackoverflow.com/questions/26243490/cells-find-error-91
I will mark this thread as solved. If you don't like Google AdSense in the posts, register or log in above. I therefore wanted to use the FIND function to find out what is the appropriate row in another dataset and then use some values from this row.
Forum Board FAQ Forum Rules Guidelines for Forum Use FAQ Forum Actions Mark Forums Read Quick Links Today's Posts Search New Posts Zero Reply Posts Subscribed Threads MrExcel Consulting Advanced Search in case the value wasn't found. –Tim Williams Feb 8 '12 at 19:35 Okay, that works, I didn't realize I had the double assignment. asked 2 years ago viewed 889 times active 2 years ago Related 4search for string in all sheets of an excel file using macros1VBA Excel 2007 - Cells.Find2How do I search Remove the message boxes but keep the If-Else-End If .
Quick Navigation Excel General Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums: Forums Home Forums HELP FORUMS Excel VBA / Macros Excel Formulas Excel General Excel FAQ HIRE Is it legal to mortgage a property twice or more? Register To Reply 11-25-2012,02:29 PM #9 AlphaFrog View Profile View Forum Posts Forum Guru Join Date 07-25-2011 Location Florida MS-Off Ver Excel 2003 Posts 5,558 Re: FIND function returns Runtime Error Is it unethical to take a photograph of my question sheets from a sit-down exam I've just finished if I am not allowed to take them home?
Edit 1 - VBA code If you want to use VBA then use this : Sub FindDevicePasteOS() 'Find corresponding OS for the device Dim intRow As Integer Dim wsht As Worksheet Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? Read this: Cross-posters Struggling to use tags (including Code tags)? : Forum tags July 28th, 2005 #3 Alc View Profile View Forum Posts I agreed to these rules Join Date 7th Thanks very much for the lesson.
Why are there no toilets on the starship 'Exciting Undertaking'? Also try not to use Select/Selection as it's almost unnecessary all the times. You have to convert it to a date using CDate. How to properly localize numbers?
Not the answer you're looking for? navigate here Hope that Helps Roy For free Excel tools & articles visit my web site If I have helped you and you feel like putting your hand in your pocket please make Unable to complete a task at work. I tried your suggestion and first I had to change LookFor from a String to a Variant type.
We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions. In cells C6:Z6, I have dates 01/01/2011 through to 01/12/2012 (in UK date format). The generated code looks like this: Range("A2").Select Application.FindFormat.Clear Application.FindFormat.NumberFormat = "dd/mm/yyyy" Application.FindFormat..... .... Check This Out Yes, my password is: Forgot your password?
Register To Reply 11-25-2012,02:12 PM #6 AlphaFrog View Profile View Forum Posts Forum Guru Join Date 07-25-2011 Location Florida MS-Off Ver Excel 2003 Posts 5,558 Re: FIND function returns Runtime Error Even with the change, the error occurs. Plus Find can error out for other reasons that an unfound match, ie starting the seach in an invalid location, looking in an invalid range etc.
here is the code: For u = 1 To 50 'copy a cell value and assign to variable y to look for anywhere u want Sheets("Sheet2").Select Cells(u, 4).Select ActiveCell.Copy ' to Changing text to value did it. How do I assign the row of found to a variable? –Brian Feb 8 '12 at 19:40 Add .row to what? Using US "chip & signature" Credit Cards abroad in "chip & PIN" countries Eating Skittles Like a Normal Person Anxious about riding in traffic after 20 year absence from cycling Is
subscribe Programmers Heaven C# School Book -Free 338 Page eBook The Programmers Heaven C# School book covers the .NET framework and the C# language. Register To Reply 11-25-2012,02:57 PM #11 AlphaFrog View Profile View Forum Posts Forum Guru Join Date 07-25-2011 Location Florida MS-Off Ver Excel 2003 Posts 5,558 Re: FIND function returns Runtime Error It takes just 2 minutes to sign up (and it's free!). this contact form Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4.
the problem is : for the 1st error( required value not found), it skips properly to next for count; but the second time it finds the exact error, it shows runtime Rule One of which requires you to use Code Tags when posting code to the Forum. Advanced Search Forum HELP FORUMS Excel General Runtime Error 91 when using Find Excel Training / Excel Dashboards Reports If this is your first visit, be sure to check out the That it occurs following the On Error Resume Next command is baffling in itself.
Can someone tell me what I'm doing wrong?^^ Thanks in advance! (oh, almost forgot: I'm using ms excel 2010 on Win7) excel vba excel-vba share|improve this question edited Mar 17 '15