Hi Phil
Although the new version of Excel for the mac supports VBA, not all things are handled. The code I presented was developed on a mac but in Virtual Machine mode (PC mode). A Forum member who actively uses Excel for the mac would have to address this issue. Sorry.