| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error check on sheet
Dim oError
On Error Resume Next Set oError = ActiveSheet.Cells.SpecialCells(xlCellTypeFormulas, xlErrors) If TypeName(oError) = "Empty" Then Debug.Print "No Error" Else Debug.Print "Error" End If Err.Clear |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Runtime 9 error Check. | Excel Worksheet Functions | |||
| Check Activesheet for chart sheet or work sheet | Charts and Charting in Excel | |||
| Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
| Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
| how to use sumif function to check date in 1 sheet is < 2 sheet | Excel Worksheet Functions | |||
Hybrid Mode
