Overflow error
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 |
Overflow error
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 |
Overflow error
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 |
Overflow error
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 |
All times are GMT +1. The time now is 04:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com