| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Error When It Can't Find Value
Not really. Using .SpecialCells(xlConstants) will still throw an error
if there are no constants in the range. In article .com, "Paul" wrote: All you have to do to get your code to work is change SpecialCells(xlConstants, xlTextValues) to SpecialCells(xlConstants) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Macro Error | Excel Discussion (Misc queries) | |||
| change error message when no more for "find" in macro to find | Excel Programming | |||
| ERROR 91 with FIND in macro | Excel Programming | |||
| can't find error in macro logic... | Excel Programming | |||
| macro error "can't find project or library" | Excel Programming | |||
Hybrid Mode
