Is it possible to run a macro automatically before every paste? I need to
paste information from another program into a merged cell (I don't like them
either, but I need them for the sheet), and I keep getting the error message
about pasting into different sized sheets.

If I can't do that, can you run a command button on a mouse click while
another cell is active(not sure if that is the right term, what I mean is
when you select a cell and hit F2 to edit the content, it has the flashing
marker)

Thanks,

David