In article . com,
says...
Tushar-
Cleaned up the formulas like you recomended and they work amazingly
fast. I don't even need the loop to copy and paste anymore, I can do
them all at once. I'm an intern at an insurance comany and this is the
first time I've ever really used Excel(to actually do something) with
VBA and am just getting the hang of it. Thanks a bunch!


Glad you got a chance to share the result of the exercise.

It is amazing how much cleaner (and faster) a design one can get with
the judicious use of intermediate result cells. I, for one, have never
understood all those who try cramming all the world's knowledge into a
single cell. Almost like there's a global shortage of XL worksheet
cells. {grin}

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions