Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Search function in excel
Hi SkipVought and DanUK86, I'm trying to reuse this code, and it doesn't seem to be working for me. here is the exact code I'm using: Sub ClearHighlights() Cells.Interior.ColorIndex = xlNone 'or choose a colorindex - use this code to clear all also End Sub Sub Button1_Click() Dim r...- samicbc
- Post #12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run-time error '57121', application-defined or object-defined error
OK, so I've done some more research... this file will open on everyone else's PC except mine without error. I have gone into Add/Remove programs and chosen to reinstall Office 2000. I've restarted, and I'm still getting the same error. What else could be different with my PC specifically? Do...- samicbc
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Run-time error '57121', application-defined or object-defined error
I have taken over a project for an employee who left, and I'm having some trouble with one of his excel workbooks. The file opens fine on my co-workers' computers but it fails when I try to open it on mine. I get a pop up that says "File error: data may have been lost" when I open the...- samicbc
- Thread
- Replies: 5
- Forum: VBA Visual Basic for Applications (Microsoft)
