Run-time error ‘91’:

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: GCF (GCF.1dpt7b_at_excelforum-nospam.com)
Date: 10/06/04 

Date: Wed, 6 Oct 2004 12:13:13 -0500

I made this code as simple as possible to get to the bottom of the
problem. Now instead of failing some of the tine, it dies all the
time. Any insight please?

Sub Macro1()
'
For i = 1 To 1000
Columns("A:A").Select
FoundIt = Selection.Find(What:=i, _

After:=ActiveCell, _
LookIn:=xlFormulas, _
LookAt:=xlPart, _
SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False).Activate

i = i + 1

Next

End Sub 

-- 
GCF
------------------------------------------------------------------------
GCF's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=4124
View this thread: http://www.excelforum.com/showthread.php?threadid=266948

Relevant Pages

  • Re: OT: why do countries become democracies?
    ... You might take a look at "The bottom billion, Why the Poorest Countries ... Are Failing and What Can Be Done About It" by Paul Collier. ...
    (talk.origins)
  • Re: When even a Republican can see it....
    ... And that when it dies it would sink ... to the bottom, taking the trapped carbon with it, where it would ...
    (rec.arts.sf.fandom)
  • My Hard Drive is Failing
    ... My hard drive is failing, ... I have a fresh new copy of XP and a bigger hard drive happily sitting on a shelf together nearby, waiting for the day when the drive just dies. ... It reminds me of the sound my battery backup makes when it switches from its external AC to its internal battery, so I'm not sure just what I'm hearing. ...
    (rec.games.computer.ultima.dragons)
  • RE: How can re-update "failed" Windows Updates?
    ... Which is the updatefailing to install? ... Scroll down towards the bottom for the latest entries to locate ... Start at the bottom and work your way up to a section that shows an ERROR, ...
    (microsoft.public.windows.vista.performance_maintenance)
  • Re: Detecting a PIPE in a program
    ... in the sense that it has a finite chance of failing on your ... conforming system. ... the broken "Reply" link at the bottom of the article. ...
    (comp.lang.c)