| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how error-trap "no cells were found error"
Thanks for any help.
I have some code in my macro: dSum = Application.Sum(Selection.SpecialCells(xlVisible)) but if there is nothing selected (at least visibly selected), I get an error "Run-time error '1004': No cells selected." Is there some kind of IF, like IF (Application.Sum...)=NULL or something so my program doesn't terminate? Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to error trap "... cannot find the data..." message? | Excel Discussion (Misc queries) | |||
| Best way to trap error to MsgBox "Too many cell formats" | Excel Discussion (Misc queries) | |||
| "trap" a compile time error | Excel Programming | |||
| Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
| How to trap the error message "Remote Data not accessible"? | Excel Programming | |||
Threaded Mode
