Fantastic macro...The only change is that I use "Int(lCap * 0.75)". I have a Proper Case macro I found a while back, this rounds out most of my macro-based formatting needs on excel.