PC Macro only partially working on Macs

[sdnorton]

Hi:

I' have a workbook done on a PC in Excel 2010. When the workbook is opened on a Mac, all of the macros work except for one. The macro in question performs some formatting on cells in column A, but the formatting is not quite right.

For example, one of the things it's supposed to do is center the text in each cell. It does this correctly on a PC, but on Macs it left justifies the text.

Below is the relevant code:

Please Login or Register  to view this content.

Any help would be greatly appreciated,

Thanks - Steve

[JosephP]

remove this

Please Login or Register  to view this content.

and it will center properly

[TMS]

I'll have to take JP's word on the actual solution ... I don't have a MAC to test it.

However, the macro could be shorter, with the same results:

Please Login or Register  to view this content.

Regards, TMS

[sdnorton]

Thanks JP. That did the trick. Much appreciated. - Steve

[sdnorton]

Thanks TMS. I'll clean the code up as you suggested. - Steve

[TMS]

You're welcome.