I think an explination of what your formula is supposed to do will help in determining how to fix it, or provide guidance to the expert vba programmers in here to solve your quandry.