Hank, the confusion came from us not understanding what the OP was talking about, he said he needed to apply a formula to 2 colums. We were all on the same page except the OP so there was a communication error. I am glad that hewas able to accomplish what he wanted to do but i don't think any of us knew what he was trying to do until his last post.
AlsoI am not saying that he needs to install a plugin to do that but ASAP utilities is useful for a myriad of shortcuts in excel and not just taking 2 steps out of the paste special method. Anyone that uses Excel much should look try it. Everyone that i have gotten to use it can't live without it now.Was this post helpful? thumb_up thumb_down