Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking errors in the formulas
i must write a macro that checks errors in formulas and returns message box saying which cell the error occured on. also it must bee when the message box opens up. i really need help.: ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking errors in the formulas
Try something like
Dim ErrCells As Range Dim Rng As Range On Error Resume Next Set ErrCells = ActiveSheet.UsedRange.SpecialCells( _ xlCellTypeFormulas, xlErrors) On Error GoTo 0 If Not ErrCells Is Nothing Then For Each Rng In ErrCells Rng.Select Beep MsgBox "Error in cell: " & Rng.Address Next Rng End If -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "cawemann" wrote in message ... i must write a macro that checks errors in formulas and returns a message box saying which cell the error occured on. also it must beep when the message box opens up. i really need help.:( ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
checking errors in the formulas
Lots of thanks for your help Mr. Pearson ! : ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I remove multiple 'errors' in Excel error checking, at the same time??? | Excel Discussion (Misc queries) | |||
Inexplicable VBA errors in formulas | Excel Discussion (Misc queries) | |||
Checking excel for errors/inconsistencies | Excel Worksheet Functions | |||
Errors in copying formulas | Excel Discussion (Misc queries) | |||
checking for errors in combobox's | Excel Programming |