Autosize Merged Cell
 

Is there anyway to run a macro or change a setting to autosize (autoadjust the height) of any merged cells in a spreadsheet. I have the autowrap option checked on the merged cells. I am running Excel 2007.

I am not very familiar with VBA code, but I understand how to create new modules and apply them to a spreadsheet.