I'm frequently getting an overflow error on this line of code

Set FindCell = .Cells.Find(What:=myPattern, _
After:=.Cells(.Cells.Count), _
lookat:=xlWhole, _
searchorder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False)


can someone help me figure out why. I've recently moved to Office 2007 and
am seeing it there when I didn't see it in Office 2003.

Thanks,
Barb Reinhardt

depending on what the With statement has, the reference to .cells.count in
xl2007 could be referring to 1048576 * 16384 cells!!
That could account for the overflow. What's the With-statement?


"Barb Reinhardt" wrote in message
...
I'm frequently getting an overflow error on this line of code

Set FindCell = .Cells.Find(What:=myPattern, _
After:=.Cells(.Cells.Count), _
lookat:=xlWhole, _
searchorder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False)


can someone help me figure out why. I've recently moved to Office 2007
and
am seeing it there when I didn't see it in Office 2003.

Thanks,
Barb Reinhardt

After:=.Cells(.Cells.Count)

Ambiguous reference. It would be better to use a Range reference here, like
Range("A" & lastRow), assuming you have defined a last row. XL2007 has a
lot of rows.


"Barb Reinhardt" wrote in message
...
I'm frequently getting an overflow error on this line of code

Set FindCell = .Cells.Find(What:=myPattern, _
After:=.Cells(.Cells.Count), _
lookat:=xlWhole, _
searchorder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False)


can someone help me figure out why. I've recently moved to Office 2007
and
am seeing it there when I didn't see it in Office 2003.

Thanks,
Barb Reinhardt

That big worksheet made .cells.count way too big.

I think you'll want to use this in xl2007:
.cells(.cells.countlarge)





Barb Reinhardt wrote:

I'm frequently getting an overflow error on this line of code

Set FindCell = .Cells.Find(What:=myPattern, _
After:=.Cells(.Cells.Count), _
lookat:=xlWhole, _
searchorder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False, _
SearchFormat:=False)


can someone help me figure out why. I've recently moved to Office 2007 and
am seeing it there when I didn't see it in Office 2003.

Thanks,
Barb Reinhardt

--

Dave Peterson