Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IsError Function
Hi again,
why doesn't work this: If IsError(.Range("1").SpecialCells(xlCellTypeBlanks) .Cells (1)) = False Then When I run the macro I get the error note "no cells were found. run-time error 1004" because the range is filled up and the macro stops instead of running the else command Thanks a lot for your help and best regards Markus |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ISERROR function | Excel Worksheet Functions | |||
Excel ISERROR function | Excel Worksheet Functions | |||
how do I write a vlookup function within an iserror function so t. | Excel Worksheet Functions | |||
Can I use ISERROR with VLOOKUP function? | Excel Programming | |||
Can I use ISERROR with VLOOKUP function? | Excel Programming |