macro to edit formula
 

Yep, merged cells suck.

I use center across selection to get the same effect without the hassle.

--
sb
"S D" wrote in message
...

The cells I was copying to had merged cells, so maybe that was the
problem. Anyways, I still learned something new from the code you sent,
thanks sb!

sd


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!