Excel Cell Merge

[drkestrel]

I am programming Excel VBA.
Methods like

MySheet.Range(theRange).Merge

works and the generated sheet could be viewed properly in Excel 97, even if saved as Excel 95 (xlExcel9795) format.

But when the file is viewed in Excel 95, nothing is merged. I know merge is a new feature for 97, but how could I use programatically 'centre across' in Excel 97's VBA??

 

[scroce]

this is probably a bad response two months late, but have you tried recording the "center across" feature as a macro and then going in to see how the macro did it?

I always do that when trying to figure out how excel features work. How much more water would there be in the ocean if it weren't for sponges?