PDA

View Full Version : AutoFit of Merged Cells



pannai
05-02-2007, 02:35 AM
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
05-02-2007, 08:59 AM
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....