D David McRitchie Aug 25, 2003 #2 Hi Tim, You're welcome, hope you looked at my page as well as just the answer. I know just when I thought I was getting the hang of C.F., sometimes it would work and sometimes it wouldn't and it was all dependent on the active cell. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
Hi Tim, You're welcome, hope you looked at my page as well as just the answer. I know just when I thought I was getting the hang of C.F., sometimes it would work and sometimes it wouldn't and it was all dependent on the active cell. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
