Was told that the solutions provided in the following thread only work on a Windows-based machine.

http://www.excelforum.com/tips-and-t...ml#post3696960

Any help on how to get this or an equivalent macro running on Excel for Mac 2011 would be greatly appreciated.

wjdr