Thanks guys for the replies. I decided to go with the non-VBA solution.
I ran into a problem though. I am stuck on the part where I select the
2 cells and enter Ctrl+Shift+Enter. When I hold these keys down
simultaneously I am not able to enter =sum_ovlp. Also, do I check R1C1
before I enter everything and then uncheck it once everything is
entered?

Thanks


--
Mark@Marc
------------------------------------------------------------------------
Mark@Marc's Profile: http://www.excelforum.com/member.php...o&userid=28126
View this thread: http://www.excelforum.com/showthread...hreadid=513668