if filter criterara misses sub needs to exit

[hudson andrew]

Hi all,

can some one please help me with minute changes to the below code . code should not work if the filter criteria is not available currently it is giving me error if no blanks in the range .

Please Login or Register  to view this content.

[kev_]

Try this:

Please Login or Register  to view this content.

Above is adequate if that is the extent of your code
But if it's part of something bigger and you want to exit the code if SpecialCells finds no cells, try something like this....

Please Login or Register  to view this content.

[hudson andrew]

Thank you this is working fine . can i use second method all the time ?.

[kev_]

Yes you can.
Thanks for the reps
Please go to Thread Tools at top of thread and mark thread as SOLVED