excel vba find runtime error 91 Cove Oregon

Address 107 Island Ave, La Grande, OR 97850
Phone (541) 297-5831
Website Link http://daleb.net/

excel vba find runtime error 91 Cove, Oregon

Member Login Remember Me Forgot your password? I get the error 91 (meaning I can't find "blah" in this case). Click here to view the relaunched Ozgrid newsletter. UPDATE heap table -> Deadlocks on RID What emergency gear and tools should I keep in my vehicle?

I run the following macro: Sub FindDate() Range("C6:Z6").Select Selection.Find(What:="01/08/2012", After:=ActiveCell, LookIn:=xlFormulas _ LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Activate End Sub and always seem to get Run-time error 91. Can a Legendary monster ignore a diviner's Portent and choose to pass the save anyway? "Rollbacked" or "rolled back" the edit? Set MyObject = Sheets(1) ' Create valid object reference. You attempted to use an object variable that has been set to Nothing.

Logical fallacy: X is bad, Y is worse, thus X is not bad How would they learn astronomy, those who don't see the stars? By the way, I tried the "on error goto" code and it didn't help at all. Register To Reply 11-25-2012,12:41 PM #3 Ivkosky View Profile View Forum Posts Registered User Join Date 04-16-2010 Location London MS-Off Ver Excel 2010 Posts 23 Re: FIND function returns Runtime Error Before posting your question, did you look here?

Just one more question - it can also happen that the value won't be there... Try something like: Dim SetPtr As String Dim rng As Range SetPtr = "Part 1" Set rng = Cells.Find(What:=SetPtr, _ After:=ActiveCell, _ LookIn:=xlValues, _ LookAt:=xlPart, _ SearchOrder:=xlByRows, _ SearchDirection:=xlNext, _ MatchCase:=False) Hot Network Questions In the United States is racial, ethnic, or national preference an acceptable hiring practice for departments or companies in some situations? The time now is 04:30 AM.

LookIn:=xlFormulas Register To Reply 11-25-2012,01:01 PM #5 Ivkosky View Profile View Forum Posts Registered User Join Date 04-16-2010 Location London MS-Off Ver Excel 2010 Posts 23 Re: FIND function returns Runtime Is it appropriate to tell my coworker my mom passed away? 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. Remove the message boxes but keep the If-Else-End If .

Remember Me? I get the error 91 (meaning I can't find "blah" in this case). All rights reserved. Stay logged in Welcome to PC Review!

Specify or respecify a reference for the object variable. 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 Sign Up Now! Tell company that I went to interview but interviewer did not respect start time How to mount a disk image from the command line? (Somewhat) generalised mean value theorem Good Term

By the way, I tried the "on error goto" code and it didn't help at all. Register To Reply + Reply to Thread « Previous Thread | Next Thread » Thread Information Users Browsing this Thread There are currently 1 users browsing this thread. (0 members and Could you please advise how to code it? Generated Sat, 15 Oct 2016 10:23:55 GMT by s_wx1131 (squid/3.5.20) Developer Network Developer Network Developer Sign in MSDN subscriptions Get tools Downloads Visual Studio MSDN subscription access SDKs Trial software Free

The time now is 03:30 AM. ⌂HomeMailSearchNewsSportsFinanceCelebrityWeatherAnswersFlickrMobileMore⋁PoliticsMoviesMusicTVGroupsStyleBeautyTechShopping Yahoo Answers 👤 Sign in ✉ Mail ⚙ Help Account Info Help Suggestions Send Feedback Answers Home All Categories Arts & Humanities Beauty & How to add an sObject to a sublislist? Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4. Similarly, a With...End With block must be initialized by executing the With statement entry point.

Cells(u,1)... I dont answer coding questions via PM or EMail. 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. Why is the spacesuit design so strange in Sunshine?

Expand» Details Details Existing questions More Tell us some more Upload in Progress Upload failed. It means that the text "Part 1" was not found. Empty cells are not a problem. 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

Share it with others Like this thread? I doubt so, but I am getting desperate and therefore trying anything possible. Also it is better to check if anything is found using If Not aCell Is Nothing Then to avoid any errors. Hello and welcome to PC Review.

Counter = "1" Do Until Counter = MaxCounter + 1 ' Inner loop. 'Set the find value Find = Workbooks("Format BDRweekly.xls").Sheets("Secs").Range("A" & Counter).Value 'Find them Workbooks("BDRweekly.xls").Activate Sheets("Sheet2").Select ActiveSheet.Cells(1, 2).Select deleteRow = Any other ideas would be very much appreciated! For example, if the Set statement is omitted in the following code, an error would be generated on the reference to MyObject:Dim MyObject As Object ' Create object variable. I used the find as I had written it.

SSjmg2477, Feb 14, 2006, in forum: Microsoft Excel Programming Replies: 2 Views: 263 SSjmg2477 Feb 14, 2006 Getting "Object Variable or With Block Variable not set" error Suraj, Feb 23, 2006, The problem is therefore with the date-time combined cells... Register To Reply 11-25-2012,12:54 PM #4 AlphaFrog View Profile View Forum Posts Forum Guru Join Date 07-25-2011 Location Florida MS-Off Ver Excel 2003 Posts 5,340 Re: FIND function returns Runtime Error Why does argv include the program name?

Please try the request again. If you don't stop and look around once in a while, you could miss it. Advanced Excel Integration XL-Dennis corner in the Excel-world OTHER STUFF DAVE HAWLEY FOUNDATION Newsletters Competitions HAV-A-CHAT Book Suggestions & Reviews Test Area Excel Development & Consultancy EXCEL SEARCH & RESOURCES Excel Video should be smaller than 600mb/5 minutes Photo should be smaller than 5mb Video should be smaller than 600mb/5 minutesPhoto should be smaller than 5mb Related Questions Excel VBA: Error 91

I get the error 91 (meaning I can't find "blah" in this case). Please post a thread in the appropriate forum section. I've been writing vba for about three weeks and have what I think is probably an easy question about handling "Find" function when no value is found. That is Cool!

You'll be able to ask any tech support questions, or chat with the community and help others. We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.