Home > Time Error > Run-time Error '91' Object Variable Or With Block Variable Not Set

Run-time Error '91' Object Variable Or With Block Variable Not Set


Just one more question - it can also happen that the value won't be there... Specify or respecify a reference for the object variable. Join them; it only takes a minute: Sign up VBA in find function runtime error 91 up vote 0 down vote favorite My question is concerning the runtime error 91 in Am I better off looping through all of the rows to see if an = exists in column J?

Empty cells are not a problem. I have noted the section causing the error. The code is the following: x=2 Sheets("Dataset2").Activate ActiveSheet.Range("AR:AR").Select ActiveSheet.Range("AR:AR").Activate Cells.Find(What:=(Sheets("Dataset1").Cells(x, 1).Value), After:=ActiveCell, LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext, MatchCase:=False, SearchFormat:=False).Activate u = ActiveCell.Row The result should be the value of "u", which will Your name or email address: Do you already have an account?

Run-time Error '91' Object Variable Or With Block Variable Not Set

In it, you'll get: The week's top questions and answers Important community announcements Questions that need answers see an example newsletter By subscribing, you agree to the privacy policy and terms Share it with others Twitter Linked In Google Reddit StumbleUpon Posting Permissions You may not post new threads You may not post replies You may not post attachments You may not My code is below.

It returned a message box "Match found in row 14899"! PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Programming > Home Home Quick Links Search Forums Recent Posts Forums Forums Quick Links Search Forums Recent Posts Articles Articles Quick How do I assign the row of found to a variable? –Brian Feb 8 '12 at 19:40 Add .row to what? Vba Runtime Error 1004 I doubt so, but I am getting desperate and therefore trying anything possible.

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 = Vba Run Time Error 91 Learning resources Microsoft Virtual Academy Channel 9 MSDN Magazine Community Forums Blogs Codeplex Support Self support Programs BizSpark (for startups) Microsoft Imagine (for students) United States (English) Newsletter Privacy & cookies Also please mention all the errors you have –Alex Oct 7 '14 at 20:21 I saw cells.find error 91 before, after I changed the code to what you suggested What is the difference between "private interests" and "parochial interests"?

You can avoid this error by setting a range object when the value is found eg: Dim SetPtr As String Dim fndRng As Range SetPtr = "Part 1" Set fndRng = Application-defined Or Object-defined Error What do each of the point-based upgrades do? Members List Calendar Forum Rules Dashboard Commercial Services Advanced Search Forum Microsoft Office Application Help - Excel Help forum Excel Programming / VBA / Macros [SOLVED] FIND function returns Runtime Error Cryptic Clue Guide Wife sent to collections for ticket she paid ten years ago more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work

Vba Run Time Error 91

First post here. Dev centers Windows Office Visual Studio Microsoft Azure More... Run-time Error '91' Object Variable Or With Block Variable Not Set Why? Excel Vba Find Error Handling Linked 255 How to avoid using Select in Excel VBA macros Related 4search for string in all sheets of an excel file using macros3vba error: object variable or with block variable

Vlookup can be used, if he switches the columns. –Branislav Kollár Mar 17 '15 at 15:11 Ooooh, must have looked over that! –CustomX Mar 17 '15 at 15:13 weblink You have to convert it to a date using CDate. We appreciate your feedback. more hot questions question feed lang-vb about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Excel Vba If Find Not Found

Asking help about a typedef expression I rolled a 20 on a stealth check. current community chat Stack Overflow Meta Stack Overflow your communities Sign up or log in to customize your list. Also not sure what you want " =isItRow =" to do but you should do it in two statements instead of trying to stack them like that. navigate here How do I catch a Ditto?

Register To Reply 11-25-2012,01: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,527 Re: FIND function returns Runtime Error Vba Error Handling the "WS1") to check the "list", find the right device, and copy the right OS into the WS1-sheet. social network graph problem Is it required to use brackets inside an integral?

First you must declare the object variable.

Moved To Office Development Please use [Code]your code goes in here[/Code] tags when posting code. What does this mean? Now I want the other sheets (e.g. I know that if there is an = sign in column J then part of the string is unwanted and can be added to Datasheet2 so the next time it comes

Get second highest value in SQL Server What reason could change people's mentality to treat each other as members of one kind? When you have received an answer to your question, please mark it as resolved using the Thread Tools menu. share|improve this answer answered Feb 8 '12 at 19:29 Jesse 1,78131323 3 Also worth adding a check If Not found Is nothing Then... It's likely that since you set dateselect = selection.TEXT, but it's looking for a DATE on the other sheet, it won't find it.

open the "list"-Sheet and find the copied entry select the cell left to the found entry and copy it open the WS1 again, select the left cell right next to the Projecting raster z-values from foot to meters?

© Copyright 2017 All rights reserved.