excel vba cells.find run-time error 91 Creede Colorado

Southern Colorado Computer Services in Monte Vista, CO is locally & family owned and has been serving the San Luis Valley with computer service and repair since 1984. We service all PCs and most Mac computers with optimization, virus removal, and hardware repair & replacement services. We have extensive knowledge of Microsoft operating systems in addition to networking and hardware and are an authorized re-seller for most major IBM PC-Compatible computer brands specializing in new and refurbished IBM/Lenovo PCs. We carry both new and refurbished LCD monitors and printers, a large stock of computer hardware and software, and a variety of computer accessories. If you need service or repair, operating system, network, or Internet consulting or installation services, please stop by or call us today.

Address 157 Adams St, Monte Vista, CO 81144
Phone (719) 480-7563
Website Link http://www.sccsonline.com

excel vba cells.find run-time error 91 Creede, Colorado

More About Us... 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) Or wsht.Name <> "Cover Sheet" Then) For intRow = 3 To wsht.Cells(Rows.Count, 3).End(xlUp).Row 'presuming there is nothing else in the column C below the devices If Not Worksheets("List").Cells.Find(what:=wsht.Cells(intRow, 3)) Is Nothing About Us PC Review is a computing review website with helpful tech support forums staffed by PC experts.

Yes, my password is: Forgot your password? Very annoying... How would you help a snapping turtle cross the road? Could it be the case that the FIND function stops when it runs to an empty cell?

Life moves pretty fast. Ferris Bueller A.K.A. Before posting your question, did you look here? Register To Reply 11-25-2012,01: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,340 Re: FIND function returns Runtime Error

Forum Today's Posts FAQ Calendar Community Groups Forum Actions Mark Forums Read Quick Links What's New? the manual way would be: select cell "C3" of WS1 and copy it. 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 excel-vba excel-2007 runtime-error share|improve this question asked Aug 16 '12 at 9:35 Spütnik 11315 you could also do it using worksheetfunction.match(...) –Dan Aug 16 '12 at 9:51 add a

Appease Your Google Overlords: Draw the "G" Logo At first I was afraid I'd be petrified How to solve the old 'gun on a spaceship' problem? How to calculate time to empty How to get this substring on bash script? Stay logged in Welcome to PC Review! My CEO wants permanent access to every employee's emails.

What are "desires of the flesh"? You may have to register before you can post: click the register link above to proceed. Could you please advise how to code it? Thanks for any guidance.

Is there a way to prevent this error? LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode 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 Cyberpunk story: Black samurai, skateboarding courier, Mafia selling pizza and Sumerian goddess as a computer virus Unusual keyboard in a picture UPDATE heap table -> Deadlocks on RID Are there any

How do I explain that this is a terrible idea? Please let me know what I need to do. Ozgrid Retains the Rights to ALL Posts and Threads Register Help Remember Me? I have noted the section causing the error.

Thanks, Mac Lingo Berkeley, CA Mac Lingo, Nov 2, 2005 #1 Advertisements Dave Peterson Guest If "Part 1" wasn't found, then you're trying to activate something that doesn't exist--and it Can an ATCo refuse to give service to an aircraft based on moral grounds? Sorry for this, but I don't want to play around with your code anymore, since it is working now... share|improve this answer answered Feb 8 '12 at 19:29 Jesse 1,78131122 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. Register To Reply 11-25-2012,01:20 PM #8 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 Not the answer you're looking for? 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 =

Is "halfly" a word? Sign up now! Good Term For "Mild" Error (Software) How to convert a set of sequential integers into a set of unique random numbers? I doubt so, but I am getting desperate and therefore trying anything possible.

My code is below. VB: deleteRow = ActiveSheet.Cells.Find(What:=Find, After:=ActiveCell, LookIn:=xlValues, _ LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _ MatchCase:=False, SearchFormat:=False).Row FYI, the whole sub looks like this: VB: Sub DeleteSecretaries() MaxCounter = SecretariesLastRow ' Initialize variables. Remove the message boxes but keep the If-Else-End If . Forum New Posts FAQ Calendar Forum Actions Mark Forums Read Quick Links Today's Posts View Site Leaders What's New?

Changing text to value did it.