Keith Williamson
Kwilliamson at RTKL.com
Thu Dec 14 14:08:55 CST 2006
Just ran across this...don't know if anyone else knew of it. When you want to have static cell references....so you want to put "$"s around the cell reference...such as: $C$1.......just click on the cell reference (in your formula)....and click F4. It automatically puts BOTH $'s around the reference. I never knew that before...so I am passing that on. Very handy! Regards, Keith E. Williamson | Assist. Controller| kwilliamson at rtkl.com RTKL Associates Inc. | 901 South Bond Street | Baltimore, Maryland 21231-3305 410-537-6098 direct | 410-276-2136 fax | www.rtkl.com