AutoFit of Merged Cells

[pannai]

Hi
I want to autofit the contents of the Merged cells within a sheet. Can anyone tell me how to do this using macro.


Thanks

[lucas]

Most here will tell you yes......get rid of the merged cells....they are much more problem than they are worth. Use center across selection instead and your code, formula's etc. will work correctly....